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

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

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

Options

rowlimitforlookups enum
  • Default -> 0
  • 1
  • 100
  • 450
  • 5000

Description

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.