Skip site navigation (1) Skip section navigation (2)

Driver seems to hang fetching data

From: Patrick Hatcher <PHatcher(at)macys(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Driver seems to hang fetching data
Date: 2007-02-28 22:19:33
Message-ID: OFC937A75F.D750BDF0-ON88257290.00793E5F-85257290.007AA316@FDS.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Responses

pgsql-odbc by date

Next:From: David GardnerDate: 2007-02-28 23:02:41
Subject: Re: Driver seems to hang fetching data
Previous:From: noreplyDate: 2007-02-28 16:31:55
Subject: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group