This is a migrated thread and some comments may be shown as answers.

load on demand data in gridview when scrolled

7 Answers 133 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Minh
Top achievements
Rank 1
Minh asked on 09 Jun 2014, 10:02 AM
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;

7 Answers, 1 is accepted

Sort by
0
Dimitrina
Telerik team
answered on 09 Jun 2014, 12:23 PM
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.
 
0
Minh
Top achievements
Rank 1
answered on 10 Jun 2014, 02:57 AM
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.
0
Minh
Top achievements
Rank 1
answered on 10 Jun 2014, 02:59 AM
oh sorry, earlier when I run my project, an error will time out, but now reappears memory error
0
Minh
Top achievements
Rank 1
answered on 10 Jun 2014, 03:02 AM
This is a timeout error, I have attached the file.
and I want to ask, where can I edit my posts
:D
0
Dimitrina
Telerik team
answered on 10 Jun 2014, 09:06 AM
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.
 
0
Minh
Top achievements
Rank 1
answered on 10 Jun 2014, 11:03 AM
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
0
Juzailie
Top achievements
Rank 2
answered on 19 Jun 2014, 09:15 AM
Have you check how much free memory during the debug time
Tags
GridView
Asked by
Minh
Top achievements
Rank 1
Answers by
Dimitrina
Telerik team
Minh
Top achievements
Rank 1
Juzailie
Top achievements
Rank 2
Share this question
or