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 ?
Re: How to speedup inserts via ADO ? |
Список | 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 по дате отправления: