RE: Crystal Reports book(s)?
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 31 Jul 2008 09:00:13 -0700 (PDT)
That's a cool tip. Thanks. If you find the URL, please share with us.
I remember a case where the Crystal Reports user asked DBAs for help with
performance. He was advised to bump up ODBC prefetch size. I think he changed
it to 10000, and the report was generated in a few minutes instead of 2 hours.
Looking at my notes about ODBC prefecth size, he must be using pre-10g Oracle's
ODBC driver:
ODBC Driver Configuration (odbcad32.exe):
Oracle ODBC:
Oracle 9iR2: Prefetch Count: 10
Oracle 10gR2: Fetch Buffer Size: 64000
Oracle 11gR1: Fetch Buffer Size: 64000
Microsoft ODBC for Oracle:
2.575.1117: Buffer Size: 65535
2.576.3959: Buffer Size: 65535
Yong Huang
> Subject: RE: Crystal Reports book(s)?
> Date: Wed, 30 Jul 2008 13:44:03 -0700
> From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
>
> The only thing I've run into before with Oracle & Crystal is that
> Crystal will (by default, I think) pull large amounts of data from
> Oracle to the client, only to aggregate it on the client side, e.g. to
> provide a report on sales totals by customer. You can configure it to
> do "server side grouping" instead and then it will pass the appropriate
> GROUP BY clause to Oracle, allowing the RDBMS to do its job and only
> return the much smaller amount of aggregated data to the client, so this
> can greatly improve the performance in certain cases. You should be
> able to google "crystal server side grouping" and get some more detail.
>
>
> Regards,
>
> Brandon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
