Roland Walter schrieb:
...
>
> I use setLong() to set the value of bc_id, but the update
> is slow, as the index on bigint does not get used.
>
> Changing the JDBC-driver to build 310 increases the speed dramatically:
> 160 updates with build 215 consumed more than 10 minutes, with build 310
> just about 3 seconds.
...
Forgot to mention that the table contains about 1.5 million rows.
--
Roland Walter
MOSAIC SOFTWARE AG
Telefon: 02225/882-411 Fax: 02225/882-201
http://www.mosaic-ag.com