hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields.
The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
