XPost: comp.databases.oracle.misc, comp.databases.oracle.server,   
   comp.databases.oracle.tools   
   From: j_gelbrich@westfalen-blatt.de   
      
   "kristoff plasun"  schrieb im Newsbeitrag   
   news:Q1%ib.57$iD6.43@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 ;)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)