Skip site navigation (1) Skip section navigation (2)

Re: How to speedup inserts via ADO ?

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-12 22:47:06
Message-ID: (view raw, whole thread or download thread mbox)
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.

Could you send me directly the Mylog output?

Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Luke ColdironDate: 2010-02-14 19:05:03
Subject: ANSI psqlodbc 08.04.0200 not working on Linux x64 with iODBC
Previous:From: Valdas RutkauskasDate: 2010-02-12 17:51:13
Subject: numeric type issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group