O'Reilly logo

Microsoft SharePoint 2010 Administration Cookbook by Peter Serzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring Resource Throttling (large lists)

At the very heart of SharePoint are lists. Just about everything in SharePoint is a list. It can be stated that SharePoint content is list driven.

One of the shortcomings of the previous version of SharePoint was that performance began to degrade if a list had more than 2000 items. This doesn't mean if a list had 2001 items, the performance degradation was noticeable. A SharePoint list could have millions of records. Let's break down exactly what happens when a user requests information from a list.

A user clicks on a link to see the items in a list. It invokes a query back to SQL to pull those items and present them. The query looks at how many columns are on that list and does a "select all" operation. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required