Re: very slow updates

> > Here is the point :
> > Using JDBC, I update one column for all the 1600 rows of a table (10
> > columns) : I'm running 1600 times a query like this :
> > for (i=0 ; i<1600 ; i++)
> > rs2.executeUpdate("UPDATE my_table SET my_date=now() WHERE id="+i);
>
> Why 1600 updates, when you could do it in one ? Either use no where
> clause (if you're really want to update all rows) or use "id>=0 AND
> id<1600" as where clause.

Of course, I simplified my real problem in this (stupid) query...
In my production environement, I don't update all the rows hence the WHERE
clause.

> Gerhard

--
Xavier Bugaud