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
13  15175 
"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 ;)
That is becuase Crystal reports suck. You can only do so much with
and ODBC connection.
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
> 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
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
> 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
[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
> 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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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.
|
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, I don't know
where to start. Is there a way to replace the '1-JUN-03' part with a
variable in...
|
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 worked just fine. I tried to
move it to another computer, but now I have to connect to an Oracle...
|
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 content is
required
- Cost is a factor - no one wants to spend too much money
|
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 rebuild the
site.
then i pass in filter criteria to the control's ".SelectionFormula"
| | |
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"
|
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:
|
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 printing straight from the Crystal Reports
|
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
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
