| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: ODBC settings |
| Date: | 2014-03-27 22:30:55 |
| Message-ID: | CALSLE1NZ3cEq6msFRmxiAR5mN2aRYfPyKzk6mfw6URMQQdyqAQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
On Thu, Mar 27, 2014 at 10:25 PM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)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
_^_
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inoue, Hiroshi | 2014-03-28 02:19:27 | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL |
| Previous Message | Barry Bell | 2014-03-27 20:02:33 | Re: ODBC 9.3.0210 not commiting, Discard ALL |