Re: Why is UseDeclareFetch so slow?

[Rainer Bauer <usenet(at)munnin(dot)com>]

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.

Rainer