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.
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\List\Settings |
Value Name | RowLimitForLookups |
Value Type | REG_DWORD |
Value | 0 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\List\Settings |
Value Name | RowLimitForLookups |
Value Type | REG_DWORD |
Value | 1 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\List\Settings |
Value Name | RowLimitForLookups |
Value Type | REG_DWORD |
Value | 100 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\List\Settings |
Value Name | RowLimitForLookups |
Value Type | REG_DWORD |
Value | 450 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\List\Settings |
Value Name | RowLimitForLookups |
Value Type | REG_DWORD |
Value | 5000 |