Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 28 Feb 2007 17:19:33 -0500
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
- Follow-Ups:
- Re: Driver seems to hang fetching data
- From: Hiroshi Inoue
- Re: Driver seems to hang fetching data
- From: David Gardner
- Re: Driver seems to hang fetching data
- Prev by Date: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
- Next by Date: Re: Driver seems to hang fetching data
- Previous by thread: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
- Next by thread: Re: Driver seems to hang fetching data
- Indexes: