SharePoint (and Project Server) Shenanigans

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 !

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.

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 !