RE: Crystal Reports book(s)?

From: Yong Huang <>
Date: Thu, 31 Jul 2008 09:00:13 -0700 (PDT)
Message-ID: <>

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" <>
> 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

Received on Thu Jul 31 2008 - 11:00:13 CDT

Original text of this message