Re: Slow Crystal Reports with Oracle

> First thing you should do is stop using the ODBC connection.

Can't, I have to use ODBC.

> Then, since
> it is not your report
> you should find someone that knows something about it and determine
> whether the issue is
> Oracle, Crystal, or the connection.

The report works fast on MSSQL, whether from CR Designer or from our program. It also works fast when the report is run from CR Designer but it crawls when run from our MFC program. Oracle server CPU usage goes to 100% whether on a p4 1.8 or a 2 CPU Xeon server. Maybe some parameters that we give cause this. How could I trace what the Oracle server is doing when it's maximizing the CPU like this?

Thanks,
kristoff plasun Received on Mon Oct 20 2003 - 20:17:30 CEST