Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    57

    Unanswered: Paging (Performance)

    Hello, I have incorporated a paging query in my software. I got the query from here:

    http://rosca.net/writing/articles/serverside_paging.asp

    My web software ususlly responded in .005 - .02 seconds with about a 100 rows of data. When I put simulated data on my database I added about 2 million rows. when I did this -- every page that did not execute the paging query responded lightning fast. But the webpages that executed the paging query took over 5 seconds. I dont understand why this paging query brought my web application to its knees.

    Does anyone know of a more efficient way to do paging. I have SQL server 2000. If it may be easier I can upgrade to SQL 2005. PLZ Let me know. Thanks

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    have a look at these two blog posts (focus on the more recent post):

    http://weblogs.sqlteam.com/jeffs/category/162.aspx

    theres a lot of info in the blog comments as well, and also links to other methods (for example, http://databases.aspfaq.com/database...recordset.html)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •