Won't fix updateResultsToJson does not batch update

[Xon]

Affected version

2.1.2

updateResultsToJson does an update per row, and doesn't do any batching for updates. This causes high latency due to the large number of update queries talking to the database when dealing with multi-million rows tables.

This makes '2.1.0 Alpha, step 18' potentially much slower then the database is separate from the php process. During a recent migration, this took ~3 hours compared to an hour for that step on an identically spec'ed single VM. While there is the 'zombie load' patching eat more performance, it shouldn't eat that much of it.

 

[Kier]

The potential for multi-part primary keys makes this challenging with the currently-abstracted code - and as this is a once-only operation, I'm not sure it really warrants development attention for the small proportion of sites that will be running separate php and db servers.