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.gardner@yu
             caipaco.com>                                               To
                                       Patrick Hatcher
             02/28/07 06:02 PM         <PHatcher@macys.com>
                                                                        cc
                                       pgsql-odbc@postgresql.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
>
>