More performant way than loading thousands of list items at once
-
Saturday, March 03, 2012 2:58 AM
Hi,
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.
Thanks
All Replies
-
Saturday, March 03, 2012 7:00 AM
Hi,
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,
http://snahta.blogspot.in/2008/11/batch-update-list-items-using-caml.html
http://blog.dynatrace.com/2009/01/20/sharepoint-using-batch-updates-to-speed-up-performance/
http://msdn.microsoft.com/en-us/library/ff798376.aspx
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.
Regards
Siva

