Hi Guys,
I am loading 800000 records in the radgrid with custom paging, it's throwing timeout error, How can i work Radgrid with large number(800000) of records, this is my requirement. but i can able to bind 200000 records in radgrid without any timeout or performance issue, so can anyone knows please suggest me
These are the following steps i have tried in my code: (Kindly note this, this radgrid i am using with in sharepoint 2007 as well as 2010)
1. i am using custom paging and set the virtual item count is 800000 and set the pagesize is 50
2. i am storing 800000 records in viewstate, not binding all 800000 records in radgrid, i am binding just 50 records at the time of loading the radgrid
3. if i change the paging in the radgrid, based on the page index i am getting 50 records from viewstate and bind it in the radgrid (for ex: current pageindex is 5 means i took 201 to 250)
4. telerik support team tell, don't use the viewstate, so i am storing all 800000 records in property bag even though it's throwing time out error
which is the best way to store all 800000 records and bind 50 records in RadGrid without performance issue, please tell me what i need to do?
I am loading 800000 records in the radgrid with custom paging, it's throwing timeout error, How can i work Radgrid with large number(800000) of records, this is my requirement. but i can able to bind 200000 records in radgrid without any timeout or performance issue, so can anyone knows please suggest me
These are the following steps i have tried in my code: (Kindly note this, this radgrid i am using with in sharepoint 2007 as well as 2010)
1. i am using custom paging and set the virtual item count is 800000 and set the pagesize is 50
2. i am storing 800000 records in viewstate, not binding all 800000 records in radgrid, i am binding just 50 records at the time of loading the radgrid
3. if i change the paging in the radgrid, based on the page index i am getting 50 records from viewstate and bind it in the radgrid (for ex: current pageindex is 5 means i took 201 to 250)
4. telerik support team tell, don't use the viewstate, so i am storing all 800000 records in property bag even though it's throwing time out error
which is the best way to store all 800000 records and bind 50 records in RadGrid without performance issue, please tell me what i need to do?
1 Answer, 1 is accepted
0
Hi Achuthan,
You must not use the ViewState for that great a number of records as this is bound to impose performance issues as has actually happened. You should also avoid storing the records in server-memory as this entails the same problem as once again has indeed occurred. In addition, do make sure that those records are not being retrieved from a SharePoint list with the GetItems method since this is known bottleneck with the SP CMS.
What I'd recommend that you do is to leave the records in their underlying store and retrieve only those needed for the current page size. If you are using SharePoint lists, do make sure that you employ CAML in order to get only the records you need.
Hope this information helps.
Best wishes, Tsvetoslav
the Telerik team
You must not use the ViewState for that great a number of records as this is bound to impose performance issues as has actually happened. You should also avoid storing the records in server-memory as this entails the same problem as once again has indeed occurred. In addition, do make sure that those records are not being retrieved from a SharePoint list with the GetItems method since this is known bottleneck with the SP CMS.
What I'd recommend that you do is to leave the records in their underlying store and retrieve only those needed for the current page size. If you are using SharePoint lists, do make sure that you employ CAML in order to get only the records you need.
Hope this information helps.
Best wishes, Tsvetoslav
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now