Re: Slow Crystal Reports with Oracle

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 19 Oct 2003 15:19:57 -0700
Message-ID: <1066515609.172520_at_yasure>

kris p wrote:

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 ...
    

I should have written, HOW does Crystal communicate with
Oracle. When a report is being printed, my application sits
idle. It's not really my code, otherwise I would probably know
the answer. The Oracle ODBC driver version is 8.1.77, win2k. 

I think I should delve more into the code and then rephrase
the question.

  

better goto comp.databases.oracle.crystalball ...
sorry, I couldnt rethitht ;)
    

:-)

kristoff plasun
  

[Quoted] First thing you should do is stop using the ODBC connection. Then, since it is not your report
[Quoted] you should find someone that knows something about it and determine whether the issue is
Oracle, Crystal, or the connection. For example it could just be a really bad report deisgn using
a lot of subreports.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Oct 20 2003 - 00:19:57 CEST