Joel Burton wrote:
> On Thu, 18 Oct 2001, [iso-8859-1] Fábio 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"
> > 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
> Does this help?
No. I didn't change even the seconds... :(
In response to
pgsql-odbc by date
|Next:||From: Joel Burton||Date: 2001-10-18 20:16:43|
|Subject: Re: ODBC Questions|
|Previous:||From: Joel Burton||Date: 2001-10-18 18:43:14|
|Subject: Re: ODBC Performance|