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?
In response to
pgsql-odbc by date
|Next:||From: Luke Coldiron||Date: 2010-02-14 19:05:03|
|Subject: ANSI psqlodbc 08.04.0200 not working on Linux x64 with iODBC|
|Previous:||From: Valdas Rutkauskas||Date: 2010-02-12 17:51:13|
|Subject: numeric type issue|