Hi Vikrant, It doesn't really sound like your report should be taking too long to run. There may be some kind of design issue or fault somewhere.Most of the issues you outline can only really have marginal improvements.
One common issue when using crystal is that you cannot really use the Remedy ODBC driver to do joins. In practice doing a join within the crystal report involves the application server doing a large number of individual queries and the overhead is massive. If you need to join 2 or more tables together then you should use a Remedy ARS join to do it and report against the join. Subreports work well when using the Remedy ODBC driver. Each subreport is effectively another query to ARS. Subreports give you a handy option to have a query defined from within Crystal itself. Perhaps if you give us a bit more information on the query and formulas you are having trouble with along with some rough row counts we may be able to help more. Rod On 1 November 2012 14:38, Vikrant <vkulka...@columnit.com> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"