HI frnds,
When iam running reports in HTML its taking only 5 t0 7 seconds but when iam running in PDF its taking more than 30 sec. Can anyone suggest me how to increase performance in PDF.
Thanks in advance...
Mrcool
Have you checked your generated sql statement? e.g. are there any full outer joins??
And you are aware of the fact that PDF does a full execute of the sql and HTML only fetches a part of the result recordset?
Hi,
how do we measure the performance of the reports? is there any specific method where we can trace the response time of all the queries used in the report?
How do we improve the report performance?
Thanks
Yep... start a DB trace tool... Like SQL Server Profiler.. That can measure all..
YEP, i did that. After tracing i found the queries is taking 7secs. When i execute the report it is taking 28secs. Is there any way to breakup the 21secs to get into more details.
As i can see these 21secs is at report level. How do i break this 21secs?
Thanks
Its bit difficult to know how these 21 secs are distributed. It takes time to put all the info in the pdf. in other words, creating the pdf document.
I can add few points for performance enhancement. set the auto group and summarise propery of TM to No. Use as many possible calculation at the cube level. If u feel this has to be done at the TM level then go ahead. And make use of tabular reference if u have multiple queries.
Srik
The main problem will be the full fetch needed to build the whole report, but this may help:
Change the default font from Andale WT Unicode (International characters size of 26 Mb) to a light-weight font such as Arial (100 Kb). This change will improve PDF rendering time.
nrh.