old nyone tell me the best practise to follow pagination in a jsp or Servlet . Suppose many database has a million records, which is the best and fastest to follow.
posted 12 years ago
I've been looking into the same thing myself with a DB2 connection. Searches on Google have returned many different options, none very elegant. One thing that I've found just recently is the CachedRowSet interface that is supplied in J2SE 1.5. It was also available separately in J2SE 1.4. However, the reference implementation does not support paging. I'm still looking if any JDBC DB2 vendor has an implementation of this interface. I have followed a trail that said that Oracle does have an implementation with paging. But I haven't found the actual code yet.