RE: Crystal Reports book(s)?

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_at_OneNeck.com>
>
> 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
      

--
http://www.freelists.org/webpage/oracle-l