Throttling and Indexing in SharePoint List

What is Throttling and Indexing in SharePoint List?

In SharePoint, List is like a table with rows and columns. Similar to SQL tables SharePoint List need indexing if contains heavy amount of data else it will degrade the performance of SharePoint application.

So what is Indexing in SharePoint List?

Indexing in SharePoint list is similar to indexing in SQL database, but in SharePoint list indexing is maintained by SharePoint and not by SQL.

Indexing columns in a SharePoint List will improve the performance. A SharePoint List support maximum 20 indices. And also remember that not all column data types can be indexed.

What is Query Throttling?

Query throttling is a new feature in SharePoint 2010. It limits the list items that will be accessed in a single request. By default its limit is 5000 for users and 20,000 for SharePoint Admin.

List View Threshold can be overridden by using below property.

To manage Query throttling settings you can use SPList.EnableThrottling.
Click Here to know more about SPList.EnableThrottling

Leave a Comment