Brion Vibber wrote:
* The updater ran for a few minutes shy of 10 hours.
Most of that time
was spent shuffling cur entries into the old table, where they
eventually become plain old text entries. The pulling of revision data
out of old (by now renamed to text) seemed to take a smaller portion of
the time, but I foolishly didn't time the individual steps.
If this proves to be a problem, we could write an external storage class
for retrieving text from the cur table, similar to the stub objects for
concatenated gzip compression. That would at least reduce the size of
the required disk writes. The whole cur row may still need to be loaded
in order to construct the page table, such is the nature of MySQL. The
text could be moved to the text table while the wiki is read/write.
-- Tim Starling