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

Re: Why is UseDeclareFetch so slow?

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Rainer Bauer <usenet(at)munnin(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Why is UseDeclareFetch so slow?
Date: 2007-06-27 14:46:20
Message-ID: 4682783C.5000705@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Rainer Bauer wrote:
> Hello Hiroshi,
> 
>>> So my questions are
>>> 1) Is there any chance the driver itself could be enhanced like Dimitri
>>> suggested here:
>>> <http://archives.postgresql.org/pgsql-performance/2007-06/msg00512.php>?
>> You can specify the fetch count in UseDeclareFetch mode using the
>>  Cache Size option or FETCH=N connection string.
> 
> Yes, but the real question is why is the query 4 times slower when
> UseDeclareFetch is enabled (FETCH was set to 100)?
> 
> I would have expected that the ODBC driver is fetching 100 rows in advance and
> thus the query should execute in less than a second instead of 30 seconds.

Could you send me directly the Mylog output ?

regards,
HIroshi Inoue

In response to

pgsql-odbc by date

Next:From: David GardnerDate: 2007-06-27 16:02:54
Subject: Re: Why is UseDeclareFetch so slow?
Previous:From: Rainer BauerDate: 2007-06-27 14:40:45
Subject: Re: Why is UseDeclareFetch so slow?

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