General Settings for Improving Performance

This section gives the information about the general settings for improving performance.

Report Server Time. Server Time must match with the time on the application server or else jobs cannot be scheduled using the scheduleNow() API.

Application Server. Tomcat is the preferred server for JVM handling.

JDK. JDK must be 1.4.2_05 or above. It must be the same as the version installed on the Matrix applicatation server.

Server to be Used.The initial Crystal Bridge used the RAS Server. The user should not use the RAS Server unless the user is manipulating the report definition itself. The job server is the recommended approach.

Disable Unnecessary Services. Unless used by the client, disable the following services, Connection Server, Desktop Intelligence Cache Server, Desktop Intelligence Job Server, Desktop Intelligence Report Server, Destination Job Server, Event Server, List of Values Job Server, Program Job Server, Report Application Server, WinHTTP Web Proxy Auto-Discovery Service, World Wide Web Publishing Service.

JVM Updates


  • Heap Size can be changed in CRConfig.xml

<JVMMaxHeap>256000000</JVMMaxHeap>

<JVMMinHeap>64000000</JVMMinHeap>


  • Try using 500 for CacheRowSetSize and QueryBatchSize. If you experience problems, revert to default of 100, the two values should be the same for best performance.
<JavaBeans>
<CacheRowSetSize>500</CacheRowSetSize>
<QueryBatchSize>500</QueryBatchSize>
    <JavaBeansClassPath>D:\Matrix\reporting.jar</JavaBeansClassPath>
</JavaBeans>