Sunday, January 3, 2010

List throttling in SharePoint 2010

I think this is very good feature because lot of end user do not know about SharePoint list item limitations. End users may be keep on adding  item to list that will hit performance of the SharePoint server.  To avoid these kind of problems MS introduced this new feature called List Threshold and Throttling in SharePoint 2010.

In SharePoint 2007(MOSS) the max items that can be returned by a list view was about 2000 items and any query over that number can result in low performance and load on the server. but in SharePoint 2010 the lists has been optimized to support millions of items and provide SharePoint Administrators control over how many items are being retrieved from the lists at a time using User Interface or Object Model.


Here is the code snippet which will insert 10000 items .


image image

The below screenshot shows that when a list has items mover than the threshold (Default 5000). 


you can get above page clicking the list settings  as shown  below.


Here is the list of various Throttling settings we can set.

image image




Suman Hasnabad said...

Hi Sreeni,
Nice article, I tried this one in my 2010 environment by adding 3000 list items programmatically and even I have set the list view threshold as 2000 for both admins and other users, I could able to see all 3000 items in a list view without giving any error.

Is there any other setting I have forgotten?

Reddy said...

Hi srini,

Thanks for the Write Up. Still you need more information on 'list thorttling' refer this post.