On a managed device, considerable time is taken in fetching and updating the Local Cache Database which affects the performance of the Agent.
You can improve the refresh time and the user login experience by enabling the Asynchronous IO and Buffer Cache feature of the ZENcache database. By enabling the Asynchronous IO feature on the SQLite database, the response of the cache on the managed device improves. The response time of Agent refresh is also faster when policies and bundles are deployed at the terminal servers. Performance is further optimized by enabling the Buffer cache to interact with SQLite database.
To optimize performance of the Adaptive Agent on a device, do the following:
Open the Registry Editor.
Go to HKLM\Software\Novell\ZCM\.
To enable the Asynchronous IO, set the SqliteAsyncIOExtension string value to True.
To enable the Buffer cache set the SqliteCache string value to True.
To allow data to persist in the cache memory for some time before flushing it to the database, set the SqliteCacheSeconds string value to 10000. This allows data to be present in the cache memory for 10000 milliseconds and all the ZENcache reads are done from the memory rather than the database which improves the performance.
To configure the number of Cache entries to be persisted in the memory as 500 before flushing to the database, set the SqliteCacheLimit string value to 500.