How to Increase the Performance of a List in Sharepoint ?

Question

Dear All Please tell me the Solution. I have a List having more than 5000 record and When I am Going to Fetch all record from list I Have getting Error like this. Web Part Error: Sandboxed code execution request failed. Correlation ID: 1b20149d-a096-2000-1387-e36b01d5c688. That's why I have used private void SearchClients() { try { using (SPSite site = new SPSite(SPContext.Current.Web.Url)) using (SPWeb sweb = site.OpenWeb()) { SPList spList = sweb.Lists[Project Details]; spList.EnableThrottling = true; SPQuery oQuery = new SPQuery(); oQuery.Query =   +   + txtClient.Text.Trim() +  ; oQuery.QueryThrottleMode = SPQueryThrottleOption.Override; oQuery.RowLimit = 3000; SPListItemCollection coll = spList.GetItems(oQuery); dt = coll.GetDataTable(); GridView2.DataSource = dt; GridView2.DataBind(); } } catch (Exception ex) { lblMsg.Text = ex.Message; } Again I have facing some problem Means Some time it's Working Fine and Some time I have got same Error . I don't Know why it's Coming again and again please tell me the solution . How to Increase the Performance of this List ?

Gowtham Rajamanickam · Answer

1. Create a blank list template without data for this list. 2. Use the list and create a new list to move some data. 3. Go to Site Settings >> Under Site Administration >> Click on Content and Structure. 4. You can use that to move your files from one list to other easily.

Rajkiran Swain · Answer

Thanks Manpreet I will try .

Manpreet Singh · Answer

Yes there is a way You can move the data in the same site easily. 1. Create a blank list template without data for this list. 2. Use the list and create a new list to move some data. 3. Go to Site Settings >> Under Site Administration >> Click on Content and Structure. 4. You can use that to move your files from one list to other easily. Let me know if you face any issue. Cheers Manpreet

Prasham Sabadra · Answer

Hi One workaround could be fetch result in batches. Like query ID field ID > 0 and ID

Rajkiran Swain · Answer

Actually i have already add more than 4000 data in the list then how to move some data to other list . Is there any solution to move data from one list to other list in a little bit of time ?

Rajkiran Swain · Answer

OK Thanks ..

Manpreet Singh · Answer

okay that's a concern now. For on-premise SharePoint the list view limit can be set on the Resource Throttling page in Central Administration However for SharePoint Online the list view threshold is 5000 which cannot be modified. Currently there are two workarounds which you can refer to: 1. Split the items into multiple lists so that no list exceeds 5000 items. For more detailed information you can refer to this article: support.microsoft.com/.../2759051 2. Create more views and sync the items to different views. Cheers Manpreet

Rajkiran Swain · Answer

Hello Manpreet thanks but i have some doubt . Actually i am working on Sharepoint online . could you please tell me the step how to increase threshold limit on sharepoint online.

Manpreet Singh · Answer

Greetings Rajkiran Kindly increase the threshold limit of your site and you will be able to perform your action. Cheers Manpreet