I seem to remember having problems with Declare/Fetch, after turning it
off I had a huge performance boost when running large reports.
Patrick Hatcher wrote:
> driver version 8.02.02
>
> I have a query that returns around 30K records. I have set the cache to
> 1000 records. It appears that while pulling data, the driver hangs for
> around 30 seconds or more and then continues to the next batch of records.
> It does this same sort of behavior whether it caching is set to 100 or
> 1000. I am using DECLARE/FETCH.
> Is there anywhere I can check for the bottle neck?
>
> Thanks.
>
> Patrick Hatcher
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>