Re: About FetchBufferSize and row caching for postgres odbc

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: PostgreSQL mailing lists <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: About FetchBufferSize and row caching for postgres odbc
Date: 2013-08-15 23:57:46
Message-ID: CAB7nPqSjUHHL-0RR5uLqVG6LKpjWxoamS9tZWn6BFBQSb3rNZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Fri, Aug 16, 2013 at 2:11 AM, Heikki Linnakangas
<hlinnakangas(at)vmware(dot)com> wrote:
> On 14.08.2013 08:26, Michael Paquier wrote:
>>
>> I got a couple of questions about the use of FetchBufferSize (one of
>> the settings of odbc.ini) and row caching in pgodbc.
>>
>> Depending on the driver used with ODBC, sometimes FetchBufferSize
>> means the maximum number of rows, or a maximum size of data that can
>> be kept on cache on client side. Which definition of FetchBufferSize
>> does pgodbc use? I assume the max number of rows... But I couldn't
>> figure out which one it is even by looking at the pgodbc documentation
>> like the one on pgfoundry
>
>
> psqlodbc doesn't have a parameter called "FetchBufferSize". Setting that in
> odbc.ini will therefore have no effect. There is a parameter called "Fetch",
> which sets the number of rows to fetch.
Oh I see. Thanks!
--
Michael

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrei Gheorghe 2013-08-16 09:00:11 Re: Calling a stored procedure with an array parameter
Previous Message Heikki Linnakangas 2013-08-15 17:11:25 Re: About FetchBufferSize and row caching for postgres odbc