使用Oracle进行慢速Crystal报表 [英] Slow Crystal Reports with Oracle
问题描述
我遇到了C ++ DCOM应用程序的问题
使用来自Oracle的数据打印Crystal Reports。
SQL查询相对复杂但是
报告是从Crystal Reports
设计师打印出来的，它显示得非常快。当我的应用程序打印报告
时，报告显示的时间大约是b / b
。
直接从Crystal Reports打印
设计器Oracle使用大约15％的CPU周期。当
从我的应用程序打印报告时Oracle
使用大约95％的CPU周期，或者有时
完全使用它，而我的应用程序在整个操作过程中，它基本上都是空闲的，直到它显示了Crystal Reports控件显示报告的结果。
任何想法为什么当报表从我的应用程序打印时，Oracle会如此努力地工作
当报表从Crystal Reports打印时
设计师
设计师？ Crystal Reports DLL如何与Oracle通信
？
提前感谢您的帮助
kristoff plasun
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
推荐答案
" kristoff plasun" < a@a.com> schrieb im Newsbeitrag
新闻：Q1％ib.57
"kristoff plasun" <a@a.com> schrieb im Newsbeitrag
news:Q1%ib.57
iD6.43@edtnps84 ...
iD6.43@edtnps84...
我遇到了问题一个C ++ DCOM应用程序，它使用来自Oracle的数据打印Crystal Reports。
SQL查询相对复杂但是当报表是从Crystal Reports
设计器打印的时候它显示得非常快。从我的应用程序打印报告
时，报告显示的时间大约是原来的十倍。
直接从Crystal Reports
设计师打印时Oracle使用大约15％的CPU周期。从我的应用程序打印报告时，Oracle
使用大约95％的CPU周期，或者有时完全使用它，而我的应用程序基本上在整个操作过程中处于空闲状态，直到它显示了Crystal Reports控件以显示报告。
当我从应用程序打印报告而不是
时，任何想法为什么Oracle会如此努力地工作？从Crystal Reports
设计师打印报告时？ Crystal Reports DLL如何与Oracle进行通信？
提前感谢您的帮助
kristoff plasun
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
您使用的是什么版本（数据库，操作系统，应用程序）？
您使用的是什么类型的应用程序（C ++ DCOM什么都不说）？
什么是SQL喜欢（大多数都是复杂的）？
等等...
更好的goto comp.databases.oracle.crystalball ...
对不起，我无法回答;）
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 ;)
这是因为Crystal报告很糟糕。你只能用
和ODBC连接做这么多。
That is becuase Crystal reports suck. You can only do so much with
and ODBC connection.
这篇关于使用Oracle进行慢速Crystal报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
