posted 13 years ago
Hello Steve,
I am able to think of a few available options. Well here they are :-
1. Fetch the rows in batches and sent those batches of rows to the client.
2. Fetch as above (in batches) but send all of them (to the client) in one go (could take time in the display) and display them on the page in a paginated manner.
3. Fetch as above (in batches) but send a few batches in an optimistic manner and raise a new request if a different batch/page is being requested for.
4. Use a taglib e.g. display-tag which does the necessary processing and help with the pagination too in a configurable manner.
Cheers,
Raj.