| From: | Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | How to speedup inserts via ADO ? |
| Date: | 2010-02-12 11:10:24 |
| Message-ID: | 4B753720.9060901@codata.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Valdas Rutkauskas | 2010-02-12 17:51:13 | numeric type issue |
| Previous Message | Don Drake | 2010-02-09 18:00:47 | Compile troubles for RHEL 5.4 and tweaks |