Using the reports cache

Caching of reports allows achieving high efficiency because of saving prepared reports in temporary files of the server. Depending on server configuration, after preparation the result can be placed in cache.

After specified time, the result of the report will be removed from the cache.

If during this time a query with the same name of the report and the same values of parameters is received from a client, the response will be immediately returned to it. The reply will be based on the result saved in cache, and will be represented in the format requested by the client.

In that case, the server will waste time only on conversion of the prepared report in the requested format without building a report. It considerably increases the productivity.

Depending on tasks performed by a server, it is possible to assign an individual storage time in cache for each particular report.

Time value is set by the administrator of a server, according to actuality of a report, after certain period of time.

For example, the annual report about activity of an enterprise can be stored in cache long enough, since the information will be relevan for a long period of time, and it would not become outdated very soon. On the contrary, a report about a large commercial organization warehouse would be relevant during a small period, and therefore it consequently should be stored in cache not too long.

Reports cache properties:

TfrxServer.Configuration.ReportCaching - enable the cache (True/False);

TfrxServer.Configuration.ReportCachePath - path to the cache folder;

TfrxServer.Configuration.DefaultCacheLatency - latency timeout, default setting is 300 seconds.

Server configurations file parameters:

[ReportsCache]
; enable caching of the reports with same params
Enabled=1
; path to chache folder
CachePath=.\cache\
; dafault delay for cache of the report results in seconds
DefaultLatency=300

The additional section of a configuration file of a server [ReportsLatency] is for customization of a storage time in cache results of one or another report:

[ReportsLatency]
; cache delay for the 1.fr3 report in seconds
1.fr3=10
; cache delay for the 2.fr3 report in seconds
2.fr3=20
; add below the any reports for the custom cache delay setup

Correction of parameters configuration will minimize time of working clients and will reduce total traffic on the server.