Re: Driver seems to hang fetching data

But doesn't turning it off cause the entire recordset to come back at once?

Patrick Hatcher

David Gardner
<david(dot)gardner(at)yu
caipaco.com> To
Patrick Hatcher
02/28/07 06:02 PM <PHatcher(at)macys(dot)com>
cc
pgsql-odbc(at)postgresql(dot)org
Subject
Re: [ODBC] Driver seems to hang
fetching data

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