Re: Why is UseDeclareFetch so slow?

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

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