Resource limit threshold

Resource limit threshold

With the increase in hardware and software, SharePoint can store more and more data. A List can store up to items or documents. However, this does not mean that SharePoint can be queried at any scale, which will impose a heavy burden on the server.

SharePoint uses Resource Throttling to limit the query scale. Log on to CentralAdministration as a Farm administrator, go to the Web Application List, select one, and click Resource Throttling on Ribbon:

The new page appears. SharePoint has default values for each item. Although this can be modified, it is not recommended to increase the value, because this will lead to slow query and increase the load of SQL Server.

1. List View Threshold:

If the maximum number of items displayed in a List View is exceeded, no results are returned. The following message is displayed in List Settings:

When the User opens this list, the following prompt is displayed:

2 List View Threshold for Auditors and Administrators

It works the same as the preceding values, except that the number of items returned by Auditors and Administrators is greater. After all, there are not many queries for Administrators and Auditors.

3 List View Lookup Threshold:

The maximum number of lookup columns that a List View can contain. Because the Look up column involves cross-table queries, too many Look Up columns will slow the query. By default, eight SharePoint instances are allowed. Note that the Look Up column, in addition to the standard List Look Up column, also contains the User/Group column, and the Status column of workflow.

4 List Unique Permissions Threshold

The format of items with independent permissions in a list. When querying, You need to perform a permission check to ensure that the user can only see items with permissions. Therefore, if a List contains too many items with independent permissions, the query slows down.