From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: How to speedup inserts via ADO ? |
Date: | 2010-02-16 03:57:52 |
Message-ID: | 4B7A17C0.5080309@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Arnaud Lesauvage wrote:
> 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 ?
1. Do inserts in a transction.
2. Set the "Level of rollback on errors" option to Transacion.
3. Use a prepared Command object.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud Lesauvage | 2010-02-16 09:43:18 | Re: How to speedup inserts via ADO ? |
Previous Message | Luke Coldiron | 2010-02-16 01:44:10 | Re: invalid byte sequence for encoding "UTF8" |