Home ›
ASP.NET Forums » Data Access » Blinq Preview » Paging - does it return all records or just some?

Paging - does it return all records or just some?

Last post 07-12-2006 2:13 AM by phuff. 1 replies.

Sort Posts:

  • Paging - does it return all records or just some?

    07-12-2006, 12:53 AM
    • Member
      15 point Member
    • joelhulen
    • Member since 07-12-2006, 4:49 AM
    • Posts 3

    Does the paging methodology retrieve all records from the database THEN display a limited result set (of, say, 20 records), or does it efficiently query and RETURN the page size (20) before displaying?

    Thanks

  • Re: Paging - does it return all records or just some?

    07-12-2006, 2:13 AM
    • Contributor
      2,680 point Contributor
    • phuff
    • Member since 06-11-2002, 8:39 AM
    • Redmond, WA
    • Posts 547
    • AspNetTeam
    The LINQ queries Blinq generates retrieve just the records it's going to display.  By default, Blinq pages have 10 records per page, so 10 records are retrieved.  You can run the SQL Profiler to see the actual query it executes.
    Polita Paulus

    This posting is provided "AS IS" with no warranties, and confers no rights.
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.