SharePoint 2010 Cookbook: Resource Throttling Settings for Large Lists

Consistent with its past behavior for this platform, SharePoint 2010 enhances those features we found to be ‘good’ with MOSS/WSS v3.0, improves upon those things we found to be ‘not so good,’ and offers us new functionality and features we wished were there in the previous iteration.  One of these improvements is the ability to work with large lists – measured the number of items included at the root of a list or in a view.

SharePoint 2010 permits a list to have up to 50 million items! Can you imagine the performance impact of such a list on the Web front-end, database, and other clients attempting to access a site which is attempting to process even half this number?!

Challenge:

How can I scale and manage large lists to optimize performance in SharePoint 2010?

Solution:

Large List Resource Throttling is a new SharePoint feature which allows limitations to be placed on a given list view.  This new feature helps mitigate degradation in performance and can be configured the farm administrators in Central Administration on a per-Web application basis.

To configure [or disable] the throttling options, simply browse to the Central Administration Web Application and, under the Application Management area, click the hyperlinked text, Manage web applications:

 

Select the Web application you’d like to configure from the list:

 

From the General Settings drop-down on the Ribbon, select Resource Throttling:

As you will see, there are a number of options from which Administrators may choose. The configurations allow SharePoint Administrators to:

  1. Set a block of time each day during which large list throttling does not occur. This time is not ‘hard and fast’ and may not be honored if, for example, a list is still rendering when the cut-off time is reached.
  2. Configure whether or not the object model can override these configurations. As a property, custom code can access and change this.
  3. Set customized permissions for Site Administrators and Auditors.

Notes:

  • Even though a large number of items [think over 500] can be displayed on a page, default, SharePoint’s paging feature will restrict this to 30 items per view with clickable arrow indicators to move forward or back through the pages.
  • The default number of items handled the database for a single operation varies based on user group. For SharePoint Administrators and Auditors, the default is 20,000 and for end users it’s 5,000.
  • Limitation: User accounts which belong to the local server administrators group are not affected the throttling settings.

See Also:


SharePoint

Applications

SharePoint apps are stand-alone applications that perform specific tasks on a SharePoint site. Apps can perform functions such as managing a discussion board or knowledge base, performing project management or time tracking tasks, or doing other workflow operations.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


SharePoint

Web Parts

Extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of Web Parts. Web Parts are the building blocks of pages on a SharePoint site that can be used to customize the user interface and content of a site page. 

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials


Essentials Plus


Bamboo Premier


Project Management Suite


Knowledge Management Suite


External User Manager


Office 365

Cloud Parts

Cloud Parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft Office 365. More than mere ports of existing software to the cloud, our Cloud Parts have been built from the ground up to take advantage of the best that the cloud has to offer.

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Cloud Parts Suite for O365/SP Onl.


Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!