Ian Coetzer
Top achievements
Rank 2
Rank 2
Ian Coetzer
asked on 25 Feb 2009, 04:51 PM
Hi
I have battled with this before and never managed to implement this correctly.
I have a datagrid (telerik rad grid) which I'm binding to say 10,000 records which is either a datatable or collection / list of items.
Now the problem is that the grid only shows 10 records (it is paged) but everytime the user navigates to the page with the grid on it has to retrieve all 10,000 records from the database, and also when the user navigates to say page 2 on the grid to see the next 10 records the application has to again retrieve all 10,000 records from the database and then bind it to the grid to show only the required 10 records.
How can I cleverly get away from this way of doing things by only returning the required records? and also bear in mind that the data in the database may change? I'm stumped no finding a solution for this one? maybe I'm just not seeing the simple solution?
Please advise if possible.
I have battled with this before and never managed to implement this correctly.
I have a datagrid (telerik rad grid) which I'm binding to say 10,000 records which is either a datatable or collection / list of items.
Now the problem is that the grid only shows 10 records (it is paged) but everytime the user navigates to the page with the grid on it has to retrieve all 10,000 records from the database, and also when the user navigates to say page 2 on the grid to see the next 10 records the application has to again retrieve all 10,000 records from the database and then bind it to the grid to show only the required 10 records.
How can I cleverly get away from this way of doing things by only returning the required records? and also bear in mind that the data in the database may change? I'm stumped no finding a solution for this one? maybe I'm just not seeing the simple solution?
Please advise if possible.
1 Answer, 1 is accepted
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 26 Feb 2009, 06:26 AM
Hi Ian,
By using Custom paging, it is possible to fetch only a fixed number of records and perform operations over this specified set of data. Telerik RadGrid allows such data manipulation through the custom paging mechanism integrated in the control. Checkout the following link for more information about custom paging in RadGrid.
Aslo refer the link which explains about Client/server grid performance optimizations.
Thanks,
Shinu.