Policy

Maximum number of rows fetched per request while populating a lookup in the SharePoint list control

The maximum number of rows fetched per request while populating a lookup in the SharePoint list control. Based on a standalone server's recommended hardware configuration a good default would be about 5000. The limit helps improve the performance of the SharePoint list control and is a defense in depth measure to prevent loading the server.

Policy
Pack Microsoft Office
Category Microsoft Office 2016 / Server Settings / SharePoint Server
Policy ID 26bf4ae84afa
Internal name L_MaximumNumberOfRows

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\list\settings\rowlimitforlookups

Policy notes

The maximum number of rows fetched per request while populating a lookup in the SharePoint list control. Based on a standalone server's recommended hardware configuration a good default would be about 5000. The limit helps improve the performance of the SharePoint list control and is a defense in depth measure to prevent loading the server.

Related policies