Re: About FetchBufferSize and row caching for postgres odbc - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: About FetchBufferSize and row caching for postgres odbc
Date
Msg-id 520D0BBD.7060700@vmware.com
Whole thread Raw
In response to About FetchBufferSize and row caching for postgres odbc  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: About FetchBufferSize and row caching for postgres odbc  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-odbc
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.

- Heikki


pgsql-odbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Calling a stored procedure with an array parameter
Next
From: Michael Paquier
Date:
Subject: Re: About FetchBufferSize and row caching for postgres odbc