Performance enhancements related to data caching

This section contains information about how the data is cached by the product:

• • Caching of modified data
  • Filtering of data source data
  • Query change for Service Request Trend for Top Catalog Title pod
  • Configurable cache interval for enumerated values

Caching of modified data

In previous releases, the product retrieved data from the source systems at regular intervals, regardless of whether the data was new or had been updated. Once the data was retrieved, it would purge the older data from its caching database. Now, the product retrieves data only if there have been updates since the last cache cycle by checking the last modified date.

Filtering of data source data

In previous releases, the product would retrieve the data from the data source and then filter the data while it was stored in memory. Now, most of the filtering is pushed to the database instead of in memory.

Query change for Service Request Trend for Top Catalog Title pod

The query used by the Service Request Trend for Top Catalog Title pod was optimized.

Configurable cache interval for enumerated values

In previous releases, the product refreshed the cache of enumerated values every hour. In this release, the enumerated value caching interval is configurable, and the default is set to one hour.

Enumerated values are values that appear in a drop-down list for form fields in the data source application such as status and priority. For example, in the BMC Remedy Change Management application, enumerated values that are available for the status field are Draft, Request for Change, Planning in Progress, Implementation in Progress, Pending, Completed, Closed, and others.

You can modify the enumerated value caching interval by updating the minutes values in the DashboardInstall\DIL\CIS\conf\dil\dil.properties file (on the BMC Atrium DIL server host) then restarting the BMC Atrium DIL service. Update the number of minutes so that the caching occurs every six hours, once every 24 hours, or the frequency appropriate for your environment. The value for each data source application can vary.

You can verify that you have set the interval correctly by viewing the changed values in the DashboardInstall\DIL\CIS\logs\cs_server.log file.

The section of the file that needs to be updated follows: