Free SQL Server 7/2000 Scripts by Webfodder
Disclaimer: There are no warranties or guarantees issued with these downloads. They are distributed as-is.
It's up to you to install them and get them working, as we DO NOT provide support for these free downloads.
Webfodder is in no way responsible for the outcome of installing or using these items. Have fun!
|
Recordset Paging Stored Procedure
|
|
Paging recordsets with SQL Server is more efficient than using ADO paging. The reason is
because of the way ADO paging works: ADO sends the entire recordset to the web server,
the web server goes to the desired page of results, sends that page to the web browser,
and then discards the unused records. This adds a lot of overhead, but it can be avoided by
paging the recordset in a stored proc. Read on...
|

|
Features
|
|
. |
Utilizes SQL Server stored procedures for scalability
|
|
: |
Reduces server overhead by sending only the desired records to the web server
|
|
.: |
Increased performance over ADO paging in high volume applications
|
|
:: |
Easy to use by sending just a few parameters to the proc
|
|

|
Requirements
|
|
. |
SQL Server 7 or higher
|
|
: |
Rights to run SQL scripts & set object permissions
|
|

|
Download Recordset Paging Stored Procedure
|
|
|
|