Performance Information

[kutoose]

Crystal Reports Version 10
Oracle 9i

I have a report for which I need to debug for performance. This report is processed on the server and there are a few sql expression fields used in the report.

Now in the Report->Performance Information box, I see that the value for 'Run Database Query' is 72786 ms. Now if I run the SQL from Database -> Show SQL it takes only 19
seconds to run in the database. Why is this disparity?

kutoose@yahoo.com

 

[IdoMillet]

Perhaps the difference is due to the time needed for the SQL expressions...

hth,
- Ido



CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Jacque]

Hi kutosse, You might want to check out the presentation from on Best Practices for Crystal Report Designers by Cathy Michitsch from the 2004 CDUGNA conference.

http://www.cdugna.org/conferences/2004/agenda/agenda.asp

Jacque