in reply to Extracting Numerous records
I could be way off since I know nothing about the actual application, but here's what I think:
To keep results consistent for the end user in the face of potential updates to the database between the initial and follow-up requests, I would probably keep a separate table containing the active "sessions" and the query results associated with that session. (Or store them by other means)
To illustrate:
Time flies when you don't know what you're doing
|
|---|