473,547 Members | 2,674 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Slow Crystal Reports with Oracle

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

Jul 19 '05 #1
13 15128
"kristoff plasun" <a@a.com> schrieb im Newsbeitrag
news:Q1%ib.57$i D6.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.crystalb all ...

sorry, I couldnt rethitht ;)


Jul 19 '05 #2
That is becuase Crystal reports suck. You can only do so much with
and ODBC connection.
Jul 19 '05 #3
no**********@my-deja.com (NorwoodThree) wrote:
That is becuase Crystal reports suck. You can only do so much with
and ODBC connection.

Crystal Reports DOES NOT require an ODBC connection to work with Oracle..It can use NativeSqlNet connectivity.
( BTW, we use it exclusively in our Enterprise environment ( both CR PRO for design and Crystal Enterprise for web
distribution) and have found it to be powerful, fast, and to have a fairly easy learning curve)
[Disclaimer: I am not now, nor have I ever been employed by Crystal Decisions ]

Just my 2c


Jul 19 '05 #4
> 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.crystalb all ...
sorry, I couldnt rethitht ;)


:-)

kristoff plasun
Jul 19 '05 #5
On Tue, 14 Oct 2003 22:47:12 GMT, kristoff plasun <a@a.com> wrote:
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?


G'day Kristoff,

Does the report use multiple tables and join them itself to produce the
result? Or does it select from a view on Oracle? Does it call a stored
procedure to do the work?

At a rough guess, it probably has a bunch of tables that it joins and
then groups to produce output. IME, Crystal does a bad job of optimising
the data access, so you are best off sorting that out on the Oracle side
by creating either a view or a stored procedure that Crystal uses.

My preference is for the stored procedure, because you can then effect
changes within Oracle, often without needing to change the Crystal
report.

To see what it is doing, open the report in the Crystal designer and
select Show SQL Query from the Database menu.

regards,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander
Jul 19 '05 #6
> G'day Kristoff,

How you doin' :-) Thanks for your reply!
Does the report use multiple tables and join them itself
to produce the result?
Well, the SQL query contains the join statements so I thought
that Oracle would be doing the work and returning the results.
Or does it select from a view on Oracle?
Nope, but I'm converting the report to use a view now, would
it make a difference?
Does it call a stored procedure to do the work?


I can't rely on that as that would involve creating stuff
on the Oracle and management wants to avoid that for reports.

How would a stored procedure work?

Thanks for your help.

kristoff plasun
Jul 19 '05 #7
[followups trimmed to comp.databases. oracle - please don't cross-post]

Kristoff wrote:
Well, the SQL query contains the join statements so I thought
that Oracle would be doing the work and returning the results.
Or does it select from a view on Oracle?
Nope, but I'm converting the report to use a view now, would
it make a difference?


In my experience, yes it will.
Does it call a stored procedure to do the work?


I can't rely on that as that would involve creating stuff
on the Oracle and management wants to avoid that for reports.


But creating a view is little different to creating a stored procedure.
Either way, you have created something on the server - ten lashes!

Which would they prefer?

a) CR brings the server to its knees every time someone runs a report,
so basic reports can only be run out of hours or against a separate,
not-quite-up-to-date data source; or

b) you build some views and stored procs in a separate schema to enable
reporting to run efficiently?
How would a stored procedure work?


At its simplest, pretty much the same as a view. However, a stored
procedure can do more than a view, especially when you use parameters to
control selection criteria, and other server-side processing.

First off though, see how you go with that view.

regards,
Ross
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander
Jul 19 '05 #8
> But creating a view is little different to creating a stored procedure.
Either way, you have created something on the server - ten lashes!
he he good point! :-)
Which would they prefer?

a) CR brings the server to its knees every time someone runs a report,
so basic reports can only be run out of hours or against a separate,
not-quite-up-to-date data source; or

b) you build some views and stored procs in a separate schema to enable
reporting to run efficiently?


I think I'll go the view way.

Thanks for your help!

kristoff plasun

Jul 19 '05 #9
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
Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4529
by: Leo_felix | last post by:
I am trying to integrate the crystal reports v9.02 in my application. The application is developed using oracle forms 6i and the database is oracle 8i. I need to call the crystal reports from my application. Can any one tell me the way of doing that by giving some sample codes. Thanks in advance.
4
9622
by: Wayne Baswell | last post by:
I want to pass a date variable to a sql statement from Crystal Reports. The part of the query accepting the variables looks like: "Calendar_Date between To_Date('1-JUN-03','mm/dd/yy') and To_Date('30-JUN-03','mm/dd/yy')" And I'd be wanting to replace the date part of the query with a user-entered date. As I'm new to Oracle and Crystal,...
0
2586
by: Max | last post by:
Hi wise people, Has anyone encountered the Crystal Reports problem I describe below? If so, how did you solve it? It seems that every article posted on google regarding CR and logon problems is still unanswered. I think I'm cursed. I originally created a crystal report which connects to a sql server server db on the same dev machine and it...
4
11415
by: Rich Moser | last post by:
My organization is in the midst of making a reporting tool decision. On the table are Crystal and the reporting functionality in Access. - Report distribution is not a factor - it's all local - Training time is a factor since we have to create a boatload of reports in a short time - The ability for users to modify report formats and data...
2
8674
by: matt | last post by:
hello, i have an .RPT file that i am using to load a report via the ASP.NET CrystalReportViewer control. i dont include my .RPTs as embedded resources...instead i load the absolute path of the .rpt (on the file system) to the control's ".ReportSource" property. i do this because i like to move new versions of the reports w/o having to...
0
2293
by: Big George | last post by:
Hello, I'm working with Visual Studio 2003 .NET and Crystal Reports for .NET. Database: Oracle 10g Develop PC: Windows XP I'm having problems trying to design a Crystal Report connecting to Oracle 10g using Microsoft OLE DB Provider for Oracle. I got this error: "ADO Error Code 0x80004005"
0
5516
by: zellipa | last post by:
I am trying to imbed crystal in oracle. I got the following steps from the web. when i try to run the created from , iget the error frm-41344. Any suggestions. Regards, Zellipa STEPS TO display the Crystal Report in Oracle Forms 6i:
13
415
by: kristoff plasun | last post by:
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...
3
3803
by: Miro | last post by:
Hi, Just wondering what a good book is on visual studios 2008 ( or 2005 if no 2008 ) that teaches you how to properly use crystal reports with it. Or im assuming that as long as I can create a dataset and link it to a reportviewer than any Crystal Report book will do. I use vb.net but im assuming most books would show you vb and c
0
7510
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7703
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7463
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6032
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5362
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3493
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3473
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1923
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1050
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.