Paging of Records Using SQL Server

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)

Paging of Records Using SQL Server

Author

Topic

ramdas
Posting Yak Master

181 Posts

Posted - 2002-09-16 : 17:25:10

Hi folks,
I am into designing a Web application which will access data from sql server 2000 database. I will need the ability to page through records retrived from the database. Are there any special strategies and/or considerations to be taken intoa ccount while designing such a process. Any pointers would be greatly appreciated.

Thank you
Bye
Ramdas

Ramdas Narayanan
SQL Server DBA

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-16 : 17:32:14

Check these out:

http://www.sqlteam.com/SearchResults.asp?SearchTerms=paging

They cover pretty much all of the available techniques and compare them. You might also want to try doing a forum search for "paging" and read those as well.

tool
Starting Member

26 Posts

Posted - 2002-09-16 : 17:41:29

I would suggest using a method in which the paging is controlled on the dbserver. I've seen some solutions (very bad ones) that did the paging on the webserver and they killed the performance of both the webserver and dbserver.

Since you've come to a SQL Server site for help I presume you're on the right path. LOL

ramdas
Posting Yak Master

181 Posts

Posted - 2002-09-16 : 20:41:11

Hi,
Thank you folks for your replies. I do intend to choose the method which makes use of the dbserver.

Bye
Ramdas

Ramdas Narayanan
SQL Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources