From: | Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu> |
---|---|
To: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: How to speedup inserts via ADO ? |
Date: | 2010-02-16 15:28:57 |
Message-ID: | 4B7AB9B9.4010704@codata.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Le 16/02/2010 16:22, Relyea, Mike a écrit :
> A word of caution that I bumped into - passthrough queries have a limit
> on the number of characters they can contain. I don't remember what
> that limit is off the top of my head but I'd guess somewhere around
> 65000. If your insert string(s) are very long you may have to split it
> up into more than one passthrough.
Thanks for the tip.
Does it also apply to queries passed directly in VBA via the
connection's "execute" method ?
If that's the case, I might try to use an ADO "command" instead.
But defining the parameters of such a command is even worse than parsing
them in an INSERT string...
--
Arnaud Lesauvage
From | Date | Subject | |
---|---|---|---|
Next Message | Valdas Rutkauskas | 2010-02-16 17:03:01 | Re: numeric type issue |
Previous Message | Relyea, Mike | 2010-02-16 14:49:45 | Re: How to speedup inserts via ADO ? |