Sharepoint 2010 Articles

Submit Article
Home » Articles » Sharepoint 2010 » GeneralRSS Feeds

Lists Throttling in SharePoint 2010

Posted By: Destin Joy     Category: Sharepoint 2010     Views: 6512

Lists Throttling in SharePoint 2010


In this article I am showing you a new feature in SharePoint 2010 called throttling

In SharePoint 2007 the max items that can be returned by a list view was approximately 2000 items and any query over this limit shall result in low performance and increased load on the server. But SharePoint P2010 list now capable of handling very large data. But most of the time we don’t want to return all of these data in a single query.  To aid with this, SP2010 introduces list throttling settings that allow us to specify how many items a user can query before the throttle kicks in and aborts the query. This applies to both the queries that retrieve through SharePoint UI or from custom code. List throttling will enabled to display an error message

SharePoint 2010 provides Administrators to control over how many items are being retrieved from the lists at a time using User Interface or Object Model. We can override it by calling RequestThrottleOverride on the SPQuery object. This will allow us to execute large unsafe queries

You can find the setting in the Central Administration under the General Setting of a Web Application


Didn't find what you were looking for? Find more on Lists Throttling in SharePoint 2010 Or get search suggestion and latest updates.

Destin Joy
Destin Joy author of Lists Throttling in SharePoint 2010 is from Pathanamthitta, India. Destin Joy says

 Hello Everyone,

I am Destin Joy from India I have MCPD in SharePoint 2010, MCTS SharePoint 2010 application development and MCTS in SharePoint 2007. I am mostly working in  core part of SharePoint (2010-2007) and passionate about new Microsoft technologies. Born and brought up in Kerala You can reach me  @ Destin.Joy@hotmail.com


View All Articles

Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

No Comment Found, Be the First to post comment!