As the items in the SharePoint list continue to grow, the performance of the queries retrieving data from the list decreases. To help SharePoint users, Microsoft has provided different Performance Control checks through “Resource Throttling” on lists in SharePoint 2010.
See bellow blog for more information
http://malikhan.wordpress.com/2009/12/22/throttling-new-features-of-list-in-sharepoint-2010-part-22/
Throttling allows realistic limit on the number of items that can be or should be queried from a SharePoint 2010 List. Although you can store the million of item in a SharePoint list, but the query operation will become slower as the size of the list grows. By allowing throttling, SharePoint 2010 has now help developers & especially Farm Administrators to control the large list & large list queries so that the performance of the whole SharePoint farm doesn’t decrease.
Ex: List View Threshold option from CentralAdmin->ApplicationManagement->GeneralSettings-Resource Throttling option
Specify the maximum number of items that a database operation can involve at one time. Operations that exceed this limit are prohibited, we can see the bellow exception "Expensive Query Exception thrown in a code".
Finally we can conclude using this future we can control the performance of SharePoint while accessing the large content, which is not possible in SharePoint 2007.
See bellow blog for more information
http://malikhan.wordpress.com/2009/12/22/throttling-new-features-of-list-in-sharepoint-2010-part-22/
Throttling allows realistic limit on the number of items that can be or should be queried from a SharePoint 2010 List. Although you can store the million of item in a SharePoint list, but the query operation will become slower as the size of the list grows. By allowing throttling, SharePoint 2010 has now help developers & especially Farm Administrators to control the large list & large list queries so that the performance of the whole SharePoint farm doesn’t decrease.
Ex: List View Threshold option from CentralAdmin->ApplicationManagement->GeneralSettings-Resource Throttling option
Specify the maximum number of items that a database operation can involve at one time. Operations that exceed this limit are prohibited, we can see the bellow exception "Expensive Query Exception thrown in a code".
Finally we can conclude using this future we can control the performance of SharePoint while accessing the large content, which is not possible in SharePoint 2007.
No comments:
Post a Comment