I am having a SharePoint list which contains millions of ite

Question

I am having a SharePoint list which contains millions of items. I want to access the items. What is the best way to achieve it. If we can access through server/client object model, how to access it without affecting the performance. Do we have any other way without using object model. The most concern point is without affecting the performance.

Priyaranjan K S · Answer

Hi, When there are more than 5000 items in sharepoint list that yiu have to query you are obviously stuck with the thresh hold limitation . This is a restriction imposed in Share Point by design . Though you can change it in Central Admin dont change it as it will cause Performance issues . You are basically left with 2 options. 1. Create a new view in the big list with a filter that will show a subset of the main data. Then query against this view in CSOM/JSOM or server side 2. Create an index on the field that comes in your CAML Query . Indexing helps to circumvent the thresh hold issue Ref :https://thedotnetter.wordpress.com/2013/04/25/spquery-and-the-list-view-threshold/ Thanks, Priyan If you found this useful Please Accept this as Answer.

Rajkiran Swain · Answer

Thanks All..

Rupali Shinde · Answer

Hi RajKiran, Please Refer below link Using Client side object Model to fetch large amount of data. Seatch for Get function under label app-data-service.js http://www.c-sharpcorner.com/UploadFile/58e23e/provider-hosted-mvc-app-with-angularjs-in-sharepoint-part/ If you found this useful Please Accept this as Answer.

Dipal Choksi · Answer

Not sure if the following info applies to lists as large as you mentioned in the OP.. Just check these out, in case it helps: http://sympmarc.com/2014/02/18/getting-around-sharepoints-threshold-limits-for-large-reference-lists/ http://www.vlieshout.net/using-select2-and-sharepoint-2013-rest-api-with-large-lists-and-infinite-scroll/ Valuable information: https://social.technet.microsoft.com/Forums/sharepoint/en-US/6f5d62e3-e52d-438d-a920-26aafd9ffbbb/sharepoint-2013-list-millions-of-records-5000-item-limit?forum=sharepointgeneral HTH!