Re: Best Way for Recordset Paging

triggers? never heard about trigger and paging.

what kind of client u r using?

"isepick" <whocares_at_microsoft.com> wrote in message news:HXBW6.78221$W02.987055_at_news1.rdc2.on.home.com...
> I have read several techniques outlined in this group for recordset
 paging:
>
> 1) Using a temp table and identity column - insert ordered rows and return
> the appropriate rows
> 2) Using triggers.
>
> Has anyone used the second technique - using triggers to returned a page
> from a recordset ? I'm looking for real life experience out there since I
> find using a temp table very slow with a large amount of records, and the
> overhead of creating and destroying the temp table to be too much.
>
> I also can't use where rownum <= X and rownum >= y since it does not order
> the query first before assigning the rownum.
>
> Any suggestions on a better approach, or how to use triggers to perform
> recordset paging ?
>
> Thanks.
>
>
Received on Sun Jun 17 2001 - 12:50:48 CDT