updateCollation.php script is awfully slow. It took over a week for
fr.wp (T56680), it'll probably take months if we ever decide to run
it on en.wp. That kinda sucks.
I'm not sure what can be done, or if it's just a problem on WMF configuration,
or what, so I'm just filing this and asking for comments. Please resolve
as INVALID if we in fact can't do anything about this.
- The workaround from T47970 which makes it use an index that's not entirely perfect for the task (but likely good enough, no idea how much slower that makes the script).
- Slave synchronisation, in which case maybe we can do something with ops involvement? Don't ask me.
- There's just too much data being sent back-and-forth between PHP and the database, in which case we can't do anything (unless we implement collating entirely database-side, which I've been told is a bad idea).
I'm CC-ing competent people. Help?