Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Fast paging?

Author  Topic  svevarn Starting Member 2 Posts Posted - 2001-08-08 : 08:43:52 Hello I was wondering if anyone could help me with figuring out which way would work fastest in my case. I have a relatively slow sql server machine (p3-800mhz,512mb ram,scsi disc) with sql 2k on it, no cluster.. and I have a quite large table "Posts" containing about 100 000 records (PostID,Headline,PostTxt) and I need to create a SP that returns 20 records depending on which page to view. and I KNOW I can create a temp-table with SortID IDENTITY(1,1) and PostID int and insert the 100 000 rows into the temp-table and select those (for example) that have SortID BETWEEN 340 AND 360. but that is kinda slow in my case. Is there a way to use a cursor in this case to improve performance? TIA /Lasse