load on demand data in gridview when scrolled

8 posts, 0 answers
  1. Minh
    Minh avatar
    13 posts
    Member since:
    Dec 2013

    Posted 09 Jun 2014 Link to this post

    Hi everyone,
    I use GridView data binding with 30 million records,
    I use "load on demand", but it only works if I load 15 million records, but 30 million records, appeared timed out errors,How to solve this error.
    Sorry my english,
    below is my code:

    var context = new NorthwindEntities();
    var query = context.Order_Details.OrderBy(o => o.OrderID);
    var view = new VirtualQueryableCollectionView(query) { LoadSize = 10 };
    DataContext = view;
  2. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 09 Jun 2014 Link to this post

    Hi,

    Would you please share more information on those timed out errors, for example the full StackTrace? 

    Regards,
    Didie
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  3. Minh
    Minh avatar
    13 posts
    Member since:
    Dec 2013

    Posted 09 Jun 2014 in reply to Dimitrina Link to this post

    thanks for the reply,
    I have attached the image, you can see the error,
    When I load too much data, the speed is very slow, is there a way to improve this?
    tks.
  4. Minh
    Minh avatar
    13 posts
    Member since:
    Dec 2013

    Posted 09 Jun 2014 Link to this post

    oh sorry, earlier when I run my project, an error will time out, but now reappears memory error
  5. Minh
    Minh avatar
    13 posts
    Member since:
    Dec 2013

    Posted 09 Jun 2014 Link to this post

    This is a timeout error, I have attached the file.
    and I want to ask, where can I edit my posts
    :D
  6. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 10 Jun 2014 Link to this post

    Hello,

    In general I would suggest you going through the Degraded Performance help article suggesting on how you could improve the performance of RadGridView. 

    As to the time-out exception, it seems to be a time-out on the server and it is not directly related to using the virtual collection. 

    Regards,
    Didie
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  7. Minh
    Minh avatar
    13 posts
    Member since:
    Dec 2013

    Posted 10 Jun 2014 in reply to Dimitrina Link to this post

    I only use:
    <telerik:RadGridView ItemsSource="{Binding}"/>
    and do not use anything more can degrade the performance of the GridView,
    code behind just like my previous posts.
    my case, I think it is difficult to fix
  8. Juzailie
    Juzailie avatar
    20 posts
    Member since:
    Apr 2013

    Posted 19 Jun 2014 Link to this post

    Have you check how much free memory during the debug time
Back to Top