Crystal Reports 2013 performance issue
We're facing a performance issue on a report designed with CR 2013 edition.
We've a heavy report with many formulas(near 30) and some queries as source (6).
The report deals with many data (up to 10'000'000)
But my question is about ressources utilization.
We refresh the report with client version and the "reading data" part takes many time.
With less data (2'500'000 lines scanned), timing metrics are as follow :
- Query : 1'537 ms
- Read Data : 1'268'070 ms
- First page layout : 1'269'712
But in task manager, I don't see a big usage by CR.
Is it possible to configure CR to use more ressources ? to parrallelize some tasks ?
refreshing the report through desktop version, is there anything to check on server side or is it irrelevant ?
Or do you know which elements can have an impact on "read data" part ? I guess it's the time spent to calculate the formulas but i'm not sure of that.
Thank you in advance for your answers.
Dell Stinnett-Christy replied
For more information about using commands and a description of why you don't want to join them together, see here: Best Practices When Using Commands with Crystal Reports