Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

pagination strategy  RSS feed

 
Pravin Panicker
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I need to incorporate pagination with a search result.
My query may return upto a lakh records and using Tomcat with db2 7.1
( No ejbs ). What would be appropriate?
- putting the entire search result in session and retrieving them on next/previous
- or hitting the database every next/previous click. Here, I plan to store the primary keys
in session, to optimize my query
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!