Re: 10 row/second insert in ssis

Hello, Bill,

10 row inserts/s is very slow, isn't it? Let's where the slow spot is.

* To know how long the server takes to execute inserts, add "log_min_duration_statement = 0" in postgresql.conf. This will record timing infomation like this in the server log:

LOG: duration: 129.236 ms statement: insert into a values(1);

* To know how long for what the ODBC driver takes, enable logging by adding the following registry values and restarting the application (SSIS?):

key: {HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER}\SOFTWARE\ODBC\ODBC.INI\<your_DSN>
value:
CommLog: REG_DWORD: 1
Debug: REG_DWORD: 1
Logdir: REG_SZ: folder path where you want to store the log files

This will create psqlodbc_<pid>.log and mylog_<pid>.log in the specified folder. <pid> is the process ID of the application using ODBC. If not found, the log files may be stored in the following places:

* C:\
* C:\podbclog
* %HOMEDRIVE%%HOMEPATH%

Regards
Takayuki Tsunakawa