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

Re: ODBC Performance

From: Joel Burton <joel(at)joelburton(dot)com>
To: Fábio Sato <sato(at)simepar(dot)br>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC Performance
Date: 2001-10-18 18:43:14
Message-ID: Pine.LNX.4.30.0110181442180.4883-100000@temp.joelburton.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Thu, 18 Oct 2001, [iso-8859-1] Fbio Sato wrote:

> > > is very disappointing... I have a procedure that update 868 rows and it is
> > > taking more than 5 minutes to complete.
>
> I think that the source code may be a better answer to your questions,
> so this is basically what I'm doing:
>
> conn.Open "DSN=mydb;uid=username;pwd=mypassword"

conn.Execute("begin")

> For I = 0 To size - 1
>   sql = "update mytable set value1 = " & array1(I) & ", value2 = " &
> array2(I) & _
>         ", value3 = " & array3(I) & ... & ", value20 = " & array20(I) &
> -
>         " where code = " & codes(I)
>   conn.Execute(sql)
> Next I

conn.Execute("commit")


Does this help?

-- 

Joel BURTON  |  joel(at)joelburton(dot)com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant


In response to

Responses

pgsql-odbc by date

Next:From: Fábio SatoDate: 2001-10-18 18:54:27
Subject: Re: ODBC Performance
Previous:From: Fábio SatoDate: 2001-10-18 18:36:36
Subject: Re: ODBC Performance

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