Post reply

Paging

  • December 5, 2009 at 4:55 am

    #96176

    I have a master table which has 100,000 records. I need to bind it to a grid in my asp.net application. Is it better to use the asp.net paging control or can i use the sql paging which is better experts kindly advise.

  • December 6, 2009 at 8:38 am

    #1088263

    In my opinion it is better to implement the paging in SQL Server. I don’t think that you’ll want the client to get 100000 records and then store them in the memory and start paging. It is better that the client will get the much smaller amount of records.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 6, 2009 at 9:39 am

    #1088270

    Wow! I agree... just imagine if only 5 people open the same screen at once... the server will have to transmit a half million rows which will totally clog the "pipe" not to mention what it will do to disk resources.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply