Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Driver seems to hang fetching data
- From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
- To: Patrick Hatcher <PHatcher(at)macys(dot)com>
- Cc: pgsql-odbc(at)postgresql(dot)org
- Subject: Re: Driver seems to hang fetching data
- Date: Thu, 01 Mar 2007 10:10:39 +0900
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?
Could send me the CommLog(psqlodbc_xxxx.log) output using the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html ? regards, Hiroshi Inoue
- References:
- Driver seems to hang fetching data
- From: Patrick Hatcher
- Driver seems to hang fetching data
- Prev by Date: Re: Driver seems to hang fetching data
- Next by Date: Re: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
- Previous by thread: Re: Driver seems to hang fetching data
- Indexes: