http://demos.telerik.com/aspnet-ajax/grid/examples/performance/linq/defaultcs.aspx
In your above performance with LINQ example, does the control return all the 300,000 rows to the memory and display only what the page require? or does it return only what the individual page need when you click on them?
Thanks
In your above performance with LINQ example, does the control return all the 300,000 rows to the memory and display only what the page require? or does it return only what the individual page need when you click on them?
Thanks
4 Answers, 1 is accepted
0
Hello Mohamed,
Sincerely yours,
Veli
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
When bound to a declarative DataSource control, RadGrid delegates paging/sorting/filtering to the data source control. So in the example, the data that is returned from the data source control is the sorted page of data you requested.
Sincerely yours,
Veli
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Mohamed
Top achievements
Rank 1
Rank 1
answered on 06 Nov 2009, 12:23 PM
Sorry Veli, I meant to ask about the performance not about how the data is returned. What makes it very quick in returning the 300,000 rows?. Even if you run a simple query to return that amount of data in sql server, it definetly takes sometime but not less than 5 secs.
Obvoiusly we know only 10 rows are displayed on each page
but does the datasource fetch 300,000 rows everytime the page no. is clicked?
How is the paging established?
I hope you understand my query?
Thanks
Obvoiusly we know only 10 rows are displayed on each page
but does the datasource fetch 300,000 rows everytime the page no. is clicked?
How is the paging established?
I hope you understand my query?
Thanks
0
Mohamed
Top achievements
Rank 1
Rank 1
answered on 06 Nov 2009, 12:32 PM
0
Hello Mohamed,
I think I understand your question. I am saying that RadGrid gets only whatever the LinqDataSource is returning it. So, effectively, RadGrid deals with the current page of data only, while the LinqDataSource is responsible for fetching the page of data among the 300,000 records. You will need to research how the LinqDataSource objects deals with so many records. Here some external links you can refer to:
LINQ to SQL (ScottGu's blog)
Intelligent paging using LINQ to SQL and the LinqDataSource control
Best wishes,
Veli
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
I think I understand your question. I am saying that RadGrid gets only whatever the LinqDataSource is returning it. So, effectively, RadGrid deals with the current page of data only, while the LinqDataSource is responsible for fetching the page of data among the 300,000 records. You will need to research how the LinqDataSource objects deals with so many records. Here some external links you can refer to:
LINQ to SQL (ScottGu's blog)
Intelligent paging using LINQ to SQL and the LinqDataSource control
Best wishes,
Veli
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.