Slow Crystal Reports with Oracle

[kristoff plasun]

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

[Howard J. Rogers]

kris p wrote:

Hi,

Yes, I'm going to try the view solution. We upgraded the server
from a p4 1.8mhz to a 2 cpu xeon, STILL Oracle maximizes
CPU cycles when running the report. How would I do an ODBC
trace? Or is there any way to get Oracle to log or show exactly
what it's doing at any given moment?

Thanks,
Kristoff Plasun

This probably tells you something about Crystal Reports rather than about
Oracle.

It also tells you something about ODBC.

Regards
HJR
--
--------------------------------------------
See my brand new website, soon to be full of
new articles: www.dizwell.com.
Nothing much there yet, but give it time!!
--------------------------------------------

[Ross McKay]

kp*****@hotmail .com (kris p) replied to a post in comp.databases. oracle
but crossposted to 3 other groups too:

Hi,

Yes, I'm going to try the view solution. We upgraded the server
from a p4 1.8mhz to a 2 cpu xeon, STILL Oracle maximizes
CPU cycles when running the report. How would I do an ODBC
trace? Or is there any way to get Oracle to log or show exactly
what it's doing at any given moment?

Pick a newsgroup, and maybe we can talk. Once again, follow-ups trimmed
to comp.databases. oracle
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander

[kris p]

> kp*****@hotmail .com (kris p) replied to a post in comp.databases. oracle

but crossposted to 3 other groups too:
:-| sorry, will stay in this group only!
Pick a newsgroup, and maybe we can talk. Once again, follow-ups trimmed
to comp.databases. oracle

OK comp.databases. oracle then

I'd like to do an ODBC trace, how would I go about doing that? Is the ODBC
trace function that is accessible through the ODBC admin what I'm looking for?

Also, is there a way to trace what the Oracle server is doing? I'd like to
see what it is doing when it's maximizing the CPU.

Thanks,
kristoff plasun

[Ross McKay]

On 20 Oct 2003 11:03:07 -0700, kp*****@hotmail .com (kris p) wrote:

I'd like to do an ODBC trace, how would I go about doing that? Is the ODBC
trace function that is accessible through the ODBC admin what I'm looking for?
Depending on the version of the ODBC Data Source Administrator you have,
you should be able to enable an ODBC trace to a log file. In my version
(3.52 on Windows 2000), there is a Tracing tab that allows you to start
or stop tracing and select the file to log to.
Also, is there a way to trace what the Oracle server is doing? I'd like to
see what it is doing when it's maximizing the CPU.

As others have said elsewhere, see Ask Tom for some articles about this.
Here is a link:

http://asktom.oracle.com/

Also, why are you using ODBC? There are better ways, e.g. the native
Oracle driver.

regards,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander