Hello, my table is clustered according to the date. Has anyone found an efficient way to page through 16 million rows of data? The query that I have takes waaaay too long. It is really fast when I page through information at the beginning but when someone tries to access the 9,000th page sometimes it has a timeout error. I am using sql server 2005 let me know if you have any ideas. Thanks
I am also thinking about switch datavase software to something that can handle that many rows. Let me know if you have a suggestion on a particular software that can handle paging through 16 million rows of data.
Hi~
You may take a look at this:
Efficiently Paging Through Large Amounts of Data (VB)
Efficiently Paging Through Large Amounts of Data(C#)
Hope this helps.
No comments:
Post a Comment