Maximum number of rows fetched per request while populating a lookup in the SharePoint list control
- Policy ID
- L_MaximumNumberOfRows
- Scope
- User Configuration
- Supported on
- At least Windows Server 2008 R2 or Windows 7
- Source
- Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
- Category
- Microsoft Office 2016 › Server Settings › SharePoint Server
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.
Options
Registry
UserHKEY_CURRENT_USER
- rowlimitforlookupsREG_DWORD