Gary, We were thinking of executing an initial query to get the total count for the criteria (using count(*)) and then page it using the offset and range that would be passed as part of the query string when clicked on the page numbers. Also we are using hibernate, which has the facility to specify offset and maxresults to retrieve the range of records to be displayed on the page.
The DisplayTag was impressive but the batch part of the implementation is still in the development stage. We couldn't find any tags that could function with a batch list... - Srini >>> [EMAIL PROTECTED] 1/23/2006 3:11:24 PM >>> >From: Rick Reumann <[EMAIL PROTECTED]> > > On 1/23/06, Srini Pillai wrote: > > > We have a situation where we require to paginate our result list (which > > is quite huge, around 1000+ records). We found few tags like DisplayTags > > from sourceforge.net but the current version does not support batch > > lists (i.e. retrieving the list in batches based on the page the user is > > in, instead of retrieving all in once). Is there a tag in Struts/JSTL > > that would help display huge lists. Any help is appreciated. > > None that I'm aware of:( Although I keep meaning to work on one. Ajax > would really be nice for this actually. You could go to the server to > get your next display and it would repopulate your display without the > whole page refreshing. > That would be slick but you would still have the problem of deciding how to batch up your results without actually retrieving the full set. You still need to determine how many rows you want to display and how many pages. Are you thinking of using something like a keyset cursor? Something similar could be implemented using the standard DAO/VO pattern. I've heard this described as ghost objects. The first data retrieval only returns the primary keys populating ghost objects. The set of keys are used to retrieve the details/rest of the object per page. Your initial inquiry returns the full set of keys matching the criteria. Gary > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
