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.
PackMicrosoft Office
CategoryMicrosoft Office 2016 / Server Settings / SharePoint Server
Policy ID
26bf4ae84afaInternal name
L_MaximumNumberOfRowsRegistry
Copy registry mappings
HKCU\software\policies\microsoft\office\16.0\list\settings\rowlimitforlookupsPolicy 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
Enable Colleague Import Outlook Add-in to work with Microsoft SharePoint ServerMaximum number of days to scan from today to determine the user's colleagues for recommendationMaximum number of items to scan from today to determine the user's colleagues for recommendationMaximum number of recipients in an Outlook item to scan to determine the user's colleagues for recommendationMinimum time before starting Colleague recommendation scanMinimum time to wait before rescanning the Outlook mailbox for new colleague recommendations