Postgres Pro
Downloads
Home   >   mailing lists

Driver seems to hang fetching data - Mailing list pgsql-odbc

From Patrick Hatcher
Subject Driver seems to hang fetching data
Date
Msg-id OFC937A75F.D750BDF0-ON88257290.00793E5F-85257290.007AA316@FDS.com
Whole thread Raw
Responses Re: Driver seems to hang fetching data  (David Gardner <david.gardner@yucaipaco.com>)
Re: Driver seems to hang fetching data  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
Tree view 
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

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Next
From: David Gardner
Date:
Subject: Re: Driver seems to hang fetching data