Got my own answer :) 1859 log files and 1 hour 45 minutes. Ouch, don't know if I will do
that one again.
________________________________________
From: Bergquist, Brett
Sent: Monday, January 09, 2012 8:57 AM
To: derby-dev@db.apache.org
Subject: Can anyone help with predicting how long/how big a transaction log will be when updating
10 Million records
I have a database upgrade that is currently running at a customer site. Little did I know
that their database table has between 10 and 11 million records. The upgrade is a updating
one column with a fixed value.
It is doing UPDATE WEEK_TABLE SET WEEK = 2
The column is a small integer. Right now there are 1400 transaction log files and growing
and it has been going for over an hour. I was wondering if there is any idea that I could
get on how many transaction log files will be needed or an idea on how long the update might
take. I know this all depends on the hardware, the size of the rows, etc., but I am just
trying get some feel on how long this might take.
Anything at all will be helpful and much appreciated.
Brett
|