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-31 15:18:40 |
Message-ID: | CALSLE1MjkxQH8BHx-31hMVKpyXF8Mqw4ePZSwZAtXX+fr9jeaQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On Fri, Mar 28, 2014 at 4:00 AM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> wrote:
> 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
>
Any Suggestions?
The same settings resulted 2x performance improvement on windows but not
the same is getting achieved on Linux.
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2014-03-31 18:55:12 | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL |
Previous Message | Barry Bell | 2014-03-31 14:56:55 | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL |