Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 apply a default query threshold of 5,000 items. Any custom code that relies on query result sets that can exceed this maximum will not perform as expected. Queries on lists consisting of more than 5,000 items that include fields that are not indexed in their query conditions will also fail, because those queries must scan all rows in a list. Follow the steps listed below to view and increase this limit or to enable the object model to override the limit:
To view and increase this threshold or to enable the object model to override the threshold
- On the Central Administration site, under Application Management, click Manage Web Applications.
- Click General Settings, and then click Resource Throttling.
- View and update the threshold or allow the object model to override the limit.