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

Re: Why is UseDeclareFetch so slow?

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Why is UseDeclareFetch so slow?
Date: 2007-06-27 14:40:45
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Hello Hiroshi,

>> 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 InoueDate: 2007-06-27 14:46:20
Subject: Re: Why is UseDeclareFetch so slow?
Previous:From: Dave PageDate: 2007-06-27 07:46:26
Subject: Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user

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