The Properties tab of the Cache Server allows you to set the location of the cache files, the maximum cache size, the maximum number of simultaneous processing threads, the number of minutes before an idle job is closed, and the number of minutes between refreshes from the database.
The "Location of the Cache Files" setting specifies the absolute path to the directory on the Cache Server machine where the cached report pages (.epf files) are stored.
Note: The cache directory should be on a drive that is local to the server.
The "Maximum Cache Size Allowed" setting limits the amount of hard disk space (in KBytes) that is used to cache reports. When the Cache Server has to handle large numbers of reports, or reports that are especially complex, a larger cache size is needed. Generally, the larger you make the cache size, the better it is able to perform.
The "Maximum Simultaneous Processing Threads" setting limits the number of concurrent reporting requests that the Cache Server processes. The default value is acceptable for most, if not all, reporting scenarios. The ideal setting for your reporting environment, however, is highly dependent upon your hardware configuration, your database software, and your reporting requirements. Thus, it is difficult to discuss the recommended or optimum settings in a general way. It is recommended that you contact your Crystal Decisions, Inc. sales representative and request information about the Crystal Enterprise Sizing Guide. A Crystal Services consultant can then assess your reporting environment and assist you in customizing these advanced configuration and performance settings.
The "Minutes Before an Idle Job is Closed" setting alters the length of time that the Cache Server waits for further requests from an idle connection. Before you change this setting, it is important to understand that setting a value too low can cause a user's request to be closed prematurely, and setting a value that is too high can cause requests to be queued while the server waits for idle jobs to be closed.
The "Minutes Between Refreshes from Database" setting determines how long cached report pages are used before new data is requested from the database. Generally, the default value is acceptable: as with other performance settings, the optimal value is largely dependent upon your reporting requirements.
In this example, the Cache Server retains most of the default settings, but the "Maximum Simultaneous Processing Threads" is decreased to 50.
Crystal Decisions, Inc. http://www.crystaldecisions.com Support services: http://support.crystaldecisions.com |