I would like to ask people what is the best approach for implementing paged items list browsing.
It seems that this is a web app presentation layer design pattern.
From what I understand everyone is saying that using scrollable result set is the right way to go. Agreeing with this statement I'd like to know what are the best practices (perhaps some code example) that people can share.
For instance, what's better, to keep the scrollable result set opened on the server side (in some session scoped object for instance) and reuse is within the same session, but then the number of opened connections can become an issue, or is it better to create new scrollable result set with every request repositioning cursor to the appropriate field, then how is it going to affect the performance and the accuracy of what items the users will see if for instance the new items where inserted in the database between user requests.
Thanks in advance.
personally I prefer to retrieve all the data into a collection and give this to the web-tier to display. Then use a jsp tag to implement the tracking of which elements to view.
Depending on the amount of data you might be able to lazy load or have to implement caching and caching updates.