home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 515 of 2,288   
   kristoff plasun to All   
   Slow Crystal Reports with Oracle   
   14 Oct 03 22:47:12   
   
   XPost: comp.databases.oracle.misc, comp.databases.oracle.server,   
   comp.databases.oracle.tools   
   From: a@a.com   
      
   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	   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca