General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
Hi Kevin,
Actually I found that the performace will break down when user selects the >> (Last Page) of the pager. I guess this is due to the records reside at the most bottom part of the selected query and thus affect the performance, and I need to use UNION to avoid duplicate records.
Is there a better approach? As some of my screens may retrieve 100k records, kindly advise.
Thanks.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only