Posted by Alexander Kuznetsov on 11/11/75 11:35

Erland Sommarskog wrote:
>
> An alternative is to use a permanent table, that would have some session
> key and an IDENTITY column (in SQL 2000). When the user makes his first
> search, you get all data into that table. Then as he pages on, you retrieve
> the rows from this table. This means you don't have to redo the query for
> subsequent pages, but can get it from the table. This is likely to give

Depending on the actual practical needs, yet another variation of this
technique is to save only the primary keys into the permanent table.
Requires less disk space and displays changes made after the PK set was
materialized.

[Back to original message]