Saturday, March 03, 2012 2:58 AM
I am working with a Sharepoint 2010 system storing thousands of items in a list and this is all loaded at once via C#. Is there any easy to implement strategy (i.e. caching?) to improve the performance of this? Lazy loading, etc.
Saturday, March 03, 2012 7:00 AM
I am also encountered the same situation. Please consider the below points to storing/retrieving large data in Sharepoint
- Use list folder for better performance. For example, I created folder for month specific.
- Use batch update for insert/update/delete operations. Refer the below link for batch update,
Note: for update folder item, include the below tag
<SetVar Name=\"RootFolder\">" + folderUrl + "</SetVar>
- Create indexes for speed retrieval.
Please get back if you need more details.