I am facing a problem. I have a JSP page which has to display records from a Database. My query retrieves around 1 lakh records. It takes 10 minutes to build the ResultSet. I believe this much of response time is not good for any web based application. Is there any way to retrieve records in multiples of hundreds. so that the response time is reduced.
Does your SQL query sort the records on one of the fields? If so, you could add something to your WHERE clause that narrows it down to a certain range. Something like:
I chose the numbers 0 and 100 as an example. Most likely this would be a "blank" that can be filled in with Java code. Also, depending on the values for sortField, this probably won't guarantee that each result set will return the same number of records.