>> So my questions are
>> 1) Is there any chance the driver itself could be enhanced like Dimitri
>> suggested here:
>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.
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2007-06-27 14:46:20|
|Subject: Re: Why is UseDeclareFetch so slow?|
|Previous:||From: Dave Page||Date: 2007-06-27 07:46:26|
|Subject: Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible
to the current user|