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.
| Author |
Topic |
|
nimesh69
Starting Member
30 Posts |
 Posted - 2001-06-26 : 13:58:45
|
| Hi all,We've developed an app using ASP/VB-COM/SQL7.At many places in the app we need to display list of records which runs into hundreds. I've used stored procs everywhere to display the list. To make it convenient to users, we're displaying paged output using features provided by ASP scripting lang.I think this is reducing performance as it gets data all the way from sql server to iis server and then chops it into pieces and displays page that is required and we get rid of other pages. The data that I'm getting rid of is travelling thru sql server to iis unnecessarily and can be avoided.Hence, I'm thinking of writing some logic in my stored proc to get only as many records as required to displayed on one page.Has anyone implemented something like this? and you mind to share the code/logic with me?Appreciate your help.Thanks!- Nimesh |
|
|
|
|
|
Paging resultset