Increasing on-demand viewing capacity

When you provide many users with View On Demand access to reports, you allow each user to view live report data by refreshing reports against your database server. The Page Server retrieves the data and performs the report processing, and the Cache Server stores recently viewed report pages for possible reuse.

If your reporting requirements demand that users have continual access to the latest data, you can increase capacity in the following ways:

• Increase the maximum allowed size of the cache. For details, see Modifying Cache Server performance settings.
• Verify the efficiency of your reports. When designing reports in Crystal Reports, there are a number of ways in which you can improve the performance of the report itself, by modifying record selection formulas, using the database server's resources to group data, incorporating parameter fields, and so on. For more information, see the "Designing Optimized Web Reports" section in the Crystal Reports User's Guide (version 8.5 and later).
• Increase the number of Page Servers that service requests on behalf of any single Cache Server. You can install additional Page Servers on multiple machines, or you can run multiple Page Servers on a single multi-processor machine (typically no more than one service/daemon per CPU).
• Increase the number of Page Servers and Cache Servers on the system, and then distribute the processing load through the use of server groups. For instance, you might create two server groups, each containing one or more Cache Server/Page Server pairs. You can then specify individual reports that should always be processed by a particular server group.