Обсуждение: ODBC settings

Поиск
Список
Период
Сортировка

ODBC settings

От
Dev Kumkar
Дата:
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?

Regards...

Re: ODBC settings

От
Dev Kumkar
Дата:
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

_^_

Re: ODBC settings

От
Dev Kumkar
Дата:

On Fri, Mar 28, 2014 at 4:00 AM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
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

Any Suggestions?
The same settings resulted 2x performance improvement on windows but not the same is getting achieved on Linux. 

Re: ODBC settings

От
Adrian Klaver
Дата:
On 03/31/2014 08:18 AM, Dev Kumkar wrote:
>

>
> Any Suggestions?
> The same settings resulted 2x performance improvement on windows but not
> the same is getting achieved on Linux.

My question would be what is the actual throughput on Windows vs Linux?

In other words 2x improvement is a relative measure not an absolute one.

Other questions:

Is the setup the same on the Windows vs Linux instances?
The client on the same machine as the server?
The same Postgres server versions?
The same psqlodbc versions?

--
Adrian Klaver
adrian.klaver@aklaver.com