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.

Supported on: At least Windows Vista



  1. Default
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\List\Settings
    Value NameRowLimitForLookups
    Value TypeREG_DWORD
    Value0
  2. 1
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\List\Settings
    Value NameRowLimitForLookups
    Value TypeREG_DWORD
    Value1
  3. 100
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\List\Settings
    Value NameRowLimitForLookups
    Value TypeREG_DWORD
    Value100
  4. 450
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\List\Settings
    Value NameRowLimitForLookups
    Value TypeREG_DWORD
    Value450
  5. 5000
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\List\Settings
    Value NameRowLimitForLookups
    Value TypeREG_DWORD
    Value5000


office12.admx

Administrative Templates (Computers)

Administrative Templates (Users)