db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <ma...@Remulak.Net>
Subject Re: Speed for millions updates
Date Sat, 18 Sep 2004 16:03:37 GMT
Hi Jin,

One thing that comes to my mind is maybe you are running your updates in
Derby's default mode of autocommit true. Putting the updates in a
transaction
by setting autocommit to false on the connection will definitely speed
things up
in case you are not doing it.

Mamta

Jianhui Jin wrote:

> Hi guys
>
> My database is about 60 million records, has simple data types, int or
> float.
> My issue is the speed to update them. My model will run on those records
> and update them in one run.
> It seems it require huge amount of time to update them, which is not
> practical for me.
>
> How to make it fast. I tried using batch, didn't help, not much
> difference to using PreparedStatement.
>
> Any helps.
>
> Jin


Mime
View raw message