db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jianhui Jin" <ced1...@leeds.ac.uk>
Subject Speed for millions updates
Date Sat, 18 Sep 2004 15:53:24 GMT
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