Set query items limit

This policy setting allows you to specify the maximum number of items that will be added to the client’s cache as the result of executing a query. Several bulk operations (especially queries) can return a large number of items to be added to the cache. This increases the size of the cache, potentially exceeding the 4GB limit imposed by Microsoft SQL Server CE. It also increases the amount of work required to keep the cache synchronized and increases the load on the LOB server. In order to protect the system, a limit is used – any results processed before reaching the limit are still committed, but the operation is marked as failed and will be retried later. If you enable this policy setting, you may specify the maximum number of items that will be added to the client’s cache as the result of executing a query. If you disable or do not configure this policy setting, a default value of 2000 items will be used.

No explicit registry values are set for enabled or disabled states.

• User
  Set errors cleanup interval

  Windows7
• User
  Set maximum number of retries when synchronization fails

  Windows7
• User
  Set maximum sleep interval

  Windows7
• User
  Set query processing timeout limit

  Windows7
• User
  Set refresh frequency limit

  Windows7
• User
  Set subscription refresh retry interval

  Windows7
• User
  Set the cleanup interval

  Windows7