Crystal XI r2, Oracle 10g r 2 and .net response time issue

[CrystalBandit]

Using Crystal Reports XI r2, Oracle 10g r2 in an .net environment and having slow Crystal Report generation time that is about 20 seconds on average. Any suggestion on where or what to look at to resolve?

 

[Turkbear]

Hi,
The very first place would be the database...Using the Show Sql option, copy and try that code on the database directly to see how long it takes to return the dataset...

Check to be sure your selection criteria is being passed to the database to handle..

What database and connection type is being used?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[CrystalBandit]

Connection type is odbc.
Ran the reports using Cyrstal Reports response was 2-3 seconds at max.

 

[BaleiroColorado]

MAYBE its the same problem:

Its Oracle 10g ISSUE.
When tables are NOT in the current SCHEMA on database,
Crystal runs a select on SYS.ALL_SYNONYMS.
This system view is bugged in 10g.
Need to replace for old version from 9i.
Thanks
Juliano