Home > SharePoint 2010 > Help – SharePoint is throttling me !

Help – SharePoint is throttling me !

Recently we have been working on a SharePoint 2007 to 2010 upgrade project, the title of this blog article is not quite the error we got from the user, but it wasn’t far off !

image

As part of the upgrade process we connected the 2007 content DB’s to the 2010 farm, and found some very large lists that were hitting the List View Threshold (LVT), which is part of the Resource Throttling settings in 2010 Central Administration.

image

image

30.000,000 items per list is the limit in 2010 http://technet.microsoft.com/en-us/library/cc262787#ListLibrary but 5000 is the LVT for best performance.

Some excellent materials about dealing with large lists are

http://technet.microsoft.com/en-us/library/cc262813.aspx and http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx

 

As for our problem, we decided to create some indexed columns and new views on the list to reduce the number of items coming back.

Happy SharePointing !

Advertisements
Categories: SharePoint 2010 Tags:

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: