Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

pagination strategy

 
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