Re: Slow Crystal Reports with Oracle

"kristoff plasun" <a_at_a.com> schrieb im Newsbeitrag news: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
>

And what versions do You use (database, OS, app) ? And what kind of app do You use (C++ DCOM says nothing) ? And what is the SQL like (most of them are "complex") ? And so forth ...

better goto comp.databases.oracle.crystalball ...

sorry, I couldnt rethitht ;) Received on Wed Oct 15 2003 - 08:32:16 CEST