For Pagination, I am supposed to follow this approach:
Client requests page 1
Cache complete result set
Return rows for page 1
Client requests page 2
Get rows from the cache and return rows for page 2
For caching the result set i am planning to use session attribute.
I need some clarifications:
1. If i store 20000 records in the session attribute, will it degrade the performance?
2. Is there any way to cache result set with out using session attribute.
Currently i am using pagination on the DB side using rownum getting the desired number of records.
The new requirement is that I am supposed to get the entire information only once from the database and cache, when ever client requests it get the information from the cache. I am really not happy to use sessions but i dont know what to do.