This content has been marked as final. Show 2 replies
Why don't you limit your querys in your sql statement? Soemthing like this
SELECT TOP(100) .....
and grab the last key (or something that can identify the last row retrieved) and when the user requests more records, go again to the db with the same procedure
I reckon you could do the paging with a servlet, which:
1. executes the query
2. caches the results on disk (against a queryID)
3. prepares the first page of results, and returns it (with the queryID)
5. subsequent pages are retrieved by queryID.
Message was edited by: corlettk = typoholic