Basic question re backend performance

Thread is closed for posting
2 posts, 0 answers
  1. Mark H
    Mark H avatar
    38 posts
    Member since:
    Aug 2008

    Posted 14 May 2009 Link to this post

    Apologies if this is a dumb question but...

    I have a page with an OADataSource and see that when hooked up to a RadGrid in full design mode with paging enabled it performs well and the queries that hit SQL2005 restrict the network traffic (ie it doesn't pull back all the rows every time and even when viewing pages later on in the dataset it only actually returns the ones you want).

    However if I implement a Best Practice BLL/BO/DB/Persistent Classes project with those layers and hook up a RadGrid in code (is there a way to do it thru the designer?) to the GetList() method - it will call that and this means the database will /always/ pull back all the records into my DB class :( THis seems to me to diminish the attraction. I need to provide efficient paging across around 50,000 rows (under extreme circumstances)

    Is there any way to get the performance of the OA data source but still use the proper layered approach?

    Is there any support planned for enhanced paging in SQL2008?

    Thanks for input,
    Mark
  2. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 15 May 2009 Link to this post

    Hello Mark H,

    Yes, it is possible to implement paging logic in code and that can be accomplished with the Take() and Skip() methods if you are using Linq to perform your queries and the Skip and MaxResultCount properties of the IQuery if you are using OQL.

    If you require more clarification on how to take advantage of the above mentioned please contact us back.

    All the best,
    Zoran
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top