struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Ruggles <a.rugg...@gmail.com>
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: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Pagination-Questions-tp20744884p20749894.html
Sent from the Struts - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Mime
View raw message