How to speedup inserts via ADO ?

Поиск
Список
Период
Сортировка
От Arnaud Lesauvage
Тема How to speedup inserts via ADO ?
Дата
Msg-id 4B753720.9060901@codata.eu
обсуждение исходный текст
Ответы Re: How to speedup inserts via ADO ?  (Hiroshi Inoue <inoue@tpf.co.jp>)
Re: How to speedup inserts via ADO ?  (Hiroshi Inoue <inoue@tpf.co.jp>)
Список pgsql-odbc
Hi all !

Inserts via ODBC are a lot slower than via native psql connection.
For instance, I have a very basic insert statement that inserts one row
in a table.
If I execute it 1000 times in pgAdmin, it returns in 718ms.
If I execute it via ADO (with a direct query : Connection.Execute
"INSERT INTO..."), it takes 15s to complete.

I checked psqlODBC's commlog, but all I see in it are the INSERT
statements that I issued. So there must be a lot of overhead somewhere,
but I don't understand where it comes from, and more important I don't
understand how I could get rid of it.

Are there some connection parameters that I could use to speed things up ?

Thanks a lot for helping !

--
Arnaud Lesauvage

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Don Drake
Дата:
Сообщение: Compile troubles for RHEL 5.4 and tweaks
Следующее
От: Valdas Rutkauskas
Дата:
Сообщение: numeric type issue