How to Increase the Performance of a List in Sharepoint ?

Rajkiran Swain

11y1.6k

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 ?

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gowtham Rajamanickam11y ago
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.
+1
Rajkiran Swain11y ago
Thanks Manpreet
I will try .
0
Manpreet Singh11y ago
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
0
Prasham Sabadra11y ago
Hi,

One workaround could be fetch result in batches. Like query ID field ID > 0 and ID < 5000. Fetch result in multiple batches and merge.
0
Rajkiran Swain11y ago
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 ?
0
Rajkiran Swain11y ago
OK
Thanks ..
0
Manpreet Singh11y ago
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 5,000 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 5,000 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
0
Rajkiran Swain11y ago
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.
0
Manpreet Singh11y ago
Greetings Rajkiran,

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

Cheers
Manpreet
0