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
Pravin R Panicker<br />SCJP,SCWCD
Being a smart alec beats the alternative. This tiny ad knows what I'm talking about:
a bit of art, as a gift, that will fit in a stocking
