Postgres Pro
Downloads
Home   >   mailing lists

Re: ODBC settings - Mailing list pgsql-odbc

From Dev Kumkar
Subject Re: ODBC settings
Date
Msg-id CALSLE1NZ3cEq6msFRmxiAR5mN2aRYfPyKzk6mfw6URMQQdyqAQ@mail.gmail.com
Whole thread Raw
In response to ODBC settings  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: ODBC settings
List pgsql-odbc
Tree view
On Thu, Mar 27, 2014 at 10:25 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
Am having a huge sql file which has only insert statements.

For me the time for loading this from a C program using psqlODBCw driver took
3 minutes.

Then added ODBC settings Protocol and UseServerSidePrepare on Linux machine but am not able to see any difference with ODBC settings here.

Windows performed better with these settings and could see improvement.

Am I missing anything on Linux side?

Is anything special needs to be done here for Linux platform?
Am clueless, I guess am setting correct parameters on odbc.ini, restart DB service:

Protocol=7.4-1
UseServerSidePrepare=1

_^_

pgsql-odbc by date:

Previous
From: Dev Kumkar
Date:
Subject: ODBC settings
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: FW: ODBC 9.3.0210 not commiting, Discard ALL