Fri, Jan 27, 2006 at 10:34:12PM +0000, Dave Page napsal(a):
> On 27/1/06 22:03, "Ludek Finstrle" <luf@pzkagis.cz> wrote:
> >> inserts the way we do (ie, not via execute, but by opening a table and then
> >> doing AddNew) it might be something to look at... anyway, the boss told us
> >
> > Hey, does I miss something? There is no support for updateable cursors
> > in 08.01 psqlodbc driver. And it is marked as experimental feature in
> > 07.03 version.
>
> You don't need updateable cursors or declare/fetch to use AddNew in ADO/VB6.
Hmm. I don't know ADO/VB6->ODBC enough :-( I have to stop answer such
questions.
> much bigger data sets on large client/server databases. If all you are doing
> is adding new records, then you might even be able to add a 'WHERE 1=2'
It could be faster to use LIMIT on pgsql. But WHERE 1=2 is more
universal across different RDBMS.
Regards,
Luf