This branch reorders the SQL statements in the big timezone migration script and adds advice from Ashok Kumar, NYPL's DBA, about executing the statements in two parallelized batches to reduce the time this migration will take.
We're going to try this out in an upcoming migration, and I'm OK with holding off merging this until we see how well it works, but I wanted to keep a record of Ashok's advice in our code base for the benefit of other folks.
This branch reorders the SQL statements in the big timezone migration script and adds advice from Ashok Kumar, NYPL's DBA, about executing the statements in two parallelized batches to reduce the time this migration will take.
We're going to try this out in an upcoming migration, and I'm OK with holding off merging this until we see how well it works, but I wanted to keep a record of Ashok's advice in our code base for the benefit of other folks.