Re: How to speedup inserts via ADO ?

From: "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "Arnaud Lesauvage" <arnaud(dot)listes(at)codata(dot)eu>
Subject: Re: How to speedup inserts via ADO ?
Date: 2010-02-16 14:49:45
Message-ID: AF7D9319B29A0242A33C3BF843BD313309F54264@USA7061MS03.na.xerox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> I have a mylog output, but it is quite huge.
> Are there any known tweaks to make inserts on linked ODBC
> tables faster?
>

Try creating a passthrough query instead. Put your insert statements
into a passthrough query and run that instead of doing the inserts on a
linked table.

Mike

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Arnaud Lesauvage 2010-02-16 15:28:57 Re: How to speedup inserts via ADO ?
Previous Message Arnaud Lesauvage 2010-02-16 14:38:53 Re: How to speedup inserts via ADO ?