You are designing a SharePoint 2010 application that has 24 lists. The application has the following
characteristics:
Some lists contain only Single line of text columns, while other lists have complex column types such as Person or Group and External Data.
.Each list contains 10,000 or more records.
Your design needs to limit the number of items in a single database
operation to 2,500.
Which approach should you recommend?
A.
Set the List View Lookup Threshold option to 2,500 items.
B.
Set the List View Threshold option to 2,500 items.
C.
Set the Number of groups to display per page property of the Group By option to 2,500 items.
D.
Set the Number of items to display property of the Item Limit option to 2,500 items.
http://office.microsoft.com/en-001/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx#_Toc264017708
List View Threshold (Default: 5,000)
Specifies the maximum number of list or library items that a database operation, such as a query, can process at one time. Operations that exceed this limit are blocked.
To give you time to make alternative plans, SharePoint 2010 warns you on the List Settings page when your list has exceeded 3,000 items. The warning contains a help link to this topic.