Enable query cache

For system performance consideration, Service Manager enables the query cache by default. When the query cache is enabled, Service Manager creates a cache table in the Production Database to save query results and the query SQL. Both the queries against the Production Database and Replicated Database are all saved in the cache table

Note When the query result is expired or you refresh the report or dashboard, Service Manager will retrieve the data by executing the query from the Production Database or Replicated Database again.

To enable the query cache, follow these steps:

  1. Open the sm.ini file. By default, the file is located on the Service Manager server in the C:\Program Files (x86)\Micro Focus\Micro Focus Service Manager 9.50\Server\RUN folder.
  2. Enter the query cache parameters and values in the file. Service Manager enables query cache by default and the default values for the parameters are shown as follows:

  3. Save the sm.ini file.

Related topics

My reports
My dashboards
Report schedule and distribution
Report administration

Related topics

Create a report
Create a dashboard
Create a report schedule

Related topics

Report descriptions and usage