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.
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
I'm glad it completed successfully.
You might want to put your experiences on the Derby hints and tips wiki. It
could come in useful to somebody else in the future.
bryan
On 01/09/2012 06:40 AM, Bergquist, Brett wrote:
Got my own answer :) 1859 log files and 1 hour 45 minutes. Ouch, don't