It was actually about merging half a dozen tables into one (a fancy denormalization), and at the same time precalculating some fields. We had gone as far as we could with indexes. The write volume is not a big deal because writes are rare on a reservation system.
