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

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 (view raw or flat)
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

pgsql-odbc by date

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

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