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

Load Data Per Page

6 Answers 146 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Attila
Top achievements
Rank 1
Attila asked on 11 May 2012, 07:00 PM

 At my organization we have been using the Rad Grid and it has been working well for us. At the moment we're only loading a few hundred records at most into the grid, and using the paging functionality to limit 20 results per page. The performance is good.

  A coworker shared a concern about potential performance issues if we have to load a very large data set into the grid. Even if the grid can handle it ok the query used to retrieve the data may take a long time. The suggestion to load the data per visible page was mentioned.  From what I can discern from the available documentation the grid requires that all up front. That is to say that it doesn't support loading only a subset of the data per page, or set of pages. However, I would just like to be able to confirm that is the case and that I'm not missing something.

Thanks.

6 Answers, 1 is accepted

Sort by
0
Elliott
Top achievements
Rank 2
answered on 11 May 2012, 08:01 PM
I don't know how you currently set your data source but the recommendation is for large grids to use LINQ to SQL
0
Attila
Top achievements
Rank 1
answered on 11 May 2012, 09:00 PM

 Thanks; we may explore that option.

 In regards to loading the data for the grid, does the control support loading per data per page (or group of pages)? Or is the only option to load all of the data at once?
0
Elliott
Top achievements
Rank 2
answered on 11 May 2012, 09:04 PM
I didn't do anything special and went with what Telerik was doing under the covers and I programmed a grid that handled 20,000+ items easily
0
Attila
Top achievements
Rank 1
answered on 11 May 2012, 09:45 PM
I appreciate the feedback, although that doesn't really answer my question. Let's just say hypothetically we have a slow database so loading the 20,000 records on the SQL ends takes a long time. Is there any option to load portions of the data, or do we have to load all the 20,000 records?

0
Accepted
Richard
Top achievements
Rank 1
answered on 15 May 2012, 05:35 PM
Attila,

You can consider the options of implementing Virtual Scrolling with Client-Side or Server-Side Data Binding, as shown in the following online demos:

Grid/Virtual Scrolling with Client-Side Binding

Grid/Virtual Scrolling and Paging (Server-side binding) - See RadGrid1 implementation which uses Advanced Data Binding and fetches data as needed.

Hope this helps!

0
Attila
Top achievements
Rank 1
answered on 15 May 2012, 09:44 PM

 Thanks jumpstart! From the looks of it the client-side binding seems to be the way to go, when you're concerned with the performance issues related to loading too much data at once.
Tags
Grid
Asked by
Attila
Top achievements
Rank 1
Answers by
Elliott
Top achievements
Rank 2
Attila
Top achievements
Rank 1
Richard
Top achievements
Rank 1
Share this question
or