10 row/second insert in ssis

From: Bill Kuhn <billkuhnjr(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: 10 row/second insert in ssis
Date: 2016-03-30 19:00:01
Message-ID: CAM5fj=bzg-TfO6n-JKh66uAC+NZv8dZLxQXgbuyTVF35JEgM2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Greetings.

Is there anything special to configure to use the 32 bit odbc driver?

I'm attempting to use the odbc driver to transfer data from microsoft sql
server to postgresql and I'm seeing dismal insert performance. It is as if
each insert is being performed individually.

The rows I'm inserting only have one integer column.

Is there anything special that needs to be done to configure the driver to
improve performance?

Many thanks.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2016-03-30 20:31:55 Re: 10 row/second insert in ssis
Previous Message Inoue, Hiroshi 2016-03-30 08:31:50 Re: Some bug fixes and improvements