Oracle Reporting Products
From: <WDELDER_at_bcsc02.gov.bc.ca>
Date: Thu, 08 Sep 94 20:17:38 PDT
Message-ID: <1702B11D63S86.WDELDER_at_bcsc02.gov.bc.ca>
Network:TCP/IP
Client: 486/66 c/w Windows 3.1/Netmange
Date: Thu, 08 Sep 94 20:17:38 PDT
Message-ID: <1702B11D63S86.WDELDER_at_bcsc02.gov.bc.ca>
We have several clients who are struggling with adhoc reporting tools. Presently, we have tried Crystal Reports, MS Access and Data Browser. We have found that we can create a simple join, add a filter and execute the query in Crystal or Access and when compared to a native SQL*Plus query with the same parameters, expect 48 minute return time vs SQL*Plus 2 seconds.
Has anyone else experimented with add-on adhoc report writers? Has anyone found one that gave acceptable performance? (Crystal Reports is a product available in Canada.) We can't be the only ones with this problem...
System: DEC Alpha
OS: OSF/1 2.0 DB: ORACLE 7.15
Network:TCP/IP
Client: 486/66 c/w Windows 3.1/Netmange
: SQL*Net 2.0
Any help would be greatly appreciated. Received on Fri Sep 09 1994 - 05:17:38 CEST