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

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: 2007-03-01 01:10:39
Message-ID: 45E6280F.7020303@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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



In response to

Responses

pgsql-odbc by date

Next:From: hengky liwandouwDate: 2007-03-01 01:51:18
Subject: Re: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Previous:From: Patrick HatcherDate: 2007-03-01 00:59:36
Subject: Re: Driver seems to hang fetching data

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