We are migrating our app to Java. Our current query runs fast in our legacy app.
Now in Using Spring we are running the query like below.
in RsExtractor we are doing while(rs.next)-- we are setting results to Value Object.
This query returns about 5000 rows.... It is very slow compare to legacy app which return in 1 sec. Using Spring JBDCTemplate it takes about 5 sec.
Any way to tune this or use different api in Spring that is faster. We have to use JDBC.