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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Gardner | 2007-06-27 16:02:54 | Re: Why is UseDeclareFetch so slow? |
Previous Message | Rainer Bauer | 2007-06-27 14:40:45 | Re: Why is UseDeclareFetch so slow? |