Slow Crystal Reports with Oracle
Date: Tue, 14 Oct 2003 22:47:12 GMT
Message-ID: <Q1%ib.57$iD6.43_at_edtnps84>
I have a problem with a C++ DCOM application that
prints Crystal Reports with data from Oracle.
The SQL query is relatively complex but when
the report is printed from the Crystal Reports
designer it shows up very fast. When the report
is printed from my application it takes about
ten times as long to get the report to appear.
When printing straight from the Crystal Reports
designer Oracle uses about 15% of CPU cycles. When
the report is printed from my application Oracle
uses about 95% of CPU cycles, or sometimes
totally uses it, while my application sits basically
idle throughout the entire operation until it shows
the Crystal Reports control to display the report.
Any idea why Oracle would be working so hard when
the report is printed from my application and not
when the report is printed from the Crystal Reports
designer? How does the Crystal Reports DLL communicate
with Oracle?
Thanks in advance for any help
kristoff plasun
Received on Wed Oct 15 2003 - 00:47:12 CEST