struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Ruggles <>
Subject Re: Pagination Questions
Date Sat, 29 Nov 2008 18:28:43 GMT

Personally I think it would be a bad idea to buffer the data from the db,
since most users when performing a search will only look at the first page
of results.  It would be better to simply return a limited set of results
from the DB.  Otherwise you might be fetching data the user will never see.

What I usually do is create an object that stores a list of the current
result set and the total number of results.  This object I create in the
data layer and requires two db calls.  One to get a limited list of results
and the second to get the total item count.

In the action I have an offset and resultsPerPage variable that I pass to my
data layer.  I don't know what database you're using but most allow you to
limit the results, using an offset and number of results.

KE LI-2 wrote:
> Dear All,
> I am currently working on pagination to the result of search result. I  
> want to ask which solution is better?
> 1. After user chooses some criterias and then clicks the search  
> button, the server will return the size of search result and the  
> objects of first page of the search result. Then when user clicks the  
> different page number, the server will get the data for that page from  
> DB. But for this solution, it requires DB access when you click the  
> page number.
> 2.After user clicks the search button, the server will get all the  
> objects(like all the films which the user wanna.). Then when user  
> clicks different page number, the server will just return the data  
> from memory. This seems to reduce the DB access times.
> 3. Use some preload method to store the data for the next few pages in  
> a buffer.
> Which solution will achieve a fast search and reduce the access load  
> to the DB?
> Thanks a lot for your feedback!
> Li, Ke (Licco)
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

View this message in context:
Sent from the Struts - User mailing list archive at

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message