Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

Possible Duplicate:
Binding 800000 records in Radgrid throwing timeout error

I am creating sample application in sharepoint 2010, i want to load 900000 records in telerik radgrid, so first i am storing all 900000 records in viewstate and get the 50 records from viewstate and bind it in radgrid due to the performance issue, but the page size goes to very huge, so it's throwing page timeout error, after that i store the 900000 records in SPWeb property bag instead of storing in viewstate eventhough it's throwing the same error, can anyone help me please. where i can able to store those (900000) values with out any timeout issue or performance issue, please help me

share|improve this question
2  
This is the third time you've posted questions that are off topic or essentially a duplicate. Consider this your last warning. – Kit Menke♦ Oct 10 '11 at 15:19

marked as duplicate by Kit Menke♦ Oct 10 '11 at 15:15

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

up vote 0 down vote

If your intended data size is 900,000 records then SharePoint is probably not the best place to manage this data as that is well beyond the recommendations of the product. It certainly can hold that many but it is not a good idea and will not perform well.

However, you could simply keep this data in a SQL database and then access it as an External List though I'm not sure how well the RADGrid works with external lists.

In either case, I seriously doubt any real user would page through 900,000 records so there isn't really a need to keep this data that close to the user (i.e. cached in WFE or viewstate)

share|improve this answer
I'm adding this in here, because the 'duplicate' thread was closed as being off topic. SharePoint can easily handle 900,000 records in a List. It all depends on the methods you use to get to that data. If you query & paginate properly, either by using SPQuery, SPSiteDataQuery or even the Search APIs (probably recommended with a list this size) you can quickly and efficiently return records in a list of any size. This is because all 900,000 wouldn't be cached on a WFE or ViewState. – James Love Oct 10 '11 at 17:42
Thanks for your reply – Rasu Oct 11 '11 at 5:44

Not the answer you're looking for? Browse other questions tagged or ask your own question.