List Throttling is the new concepts introduced in SharePoint 2010 to set the limits on the rows of data can be retrieved from a SharePoint list or document library at one time. Suppose a SharePoint lists contains two thousand records and someone trying to retrieve all items, then List throttling will not allow to do so.
Throttling setting will be apply for both views created by the user also for queries executed in custom code also. When executing queries, the number of results returned will be determined by the throttle settings for the given list and the rights of the current user.
You have to set the Throttling settings in the Central Administration.
The default value for this setting is 5,000, which means that results returned from an SPQuery or SPSiteDataQuery object will be generally limited to 5,000 items for both super users and normal users.
You can check this article for more. http://blogs.technet.com/b/speschka/archive/2009/10/27/working-with-large-lists-in-sharepoint-2010-list-throttling.aspx
Throttling setting will be apply for both views created by the user also for queries executed in custom code also. When executing queries, the number of results returned will be determined by the throttle settings for the given list and the rights of the current user.
You have to set the Throttling settings in the Central Administration.
The default value for this setting is 5,000, which means that results returned from an SPQuery or SPSiteDataQuery object will be generally limited to 5,000 items for both super users and normal users.
You can check this article for more. http://blogs.technet.com/b/speschka/archive/2009/10/27/working-with-large-lists-in-sharepoint-2010-list-throttling.aspx