Which one to use ResultSet or CashedRowSet?

[amarshi mohanty]

Hi All,
I need to display 2031 pages in my jsp (with pagination) and at the top inside grid i will be diaplying 16 rows i.e 16 record per page.
If i ma fetching all the 2031 * 16 record and displaying first 16 records and puting the remainig record in a pagination class , so that nest time onward if i click any of 2 - 2031 page i wll fetch corresponding record for the selected page from the paginatin class. this works fine , but because i m fetching all the record at a time , theer is a performance pblm.

So i need to hit the database for each page click.
For this which one would be a better optin ResultSet or CachedRowSet?



Thanks
Amarshi

[Paul Sturrock]

If you know you are using paging why get all the records at once? This kind of defeats one of the purposes of paging. Caching c32000 records sounds like a bad thing to do.