Just to be very clear, even with the indexing there are periods where 4000% CPU is required, so we still had to move to the larger server. And we were aware that indexing would help from the moment we saw that query, but we were trying to get a more "professional" look by WHMCS first regarding the issue as a whole and perhaps have them suggest specific indexing or improve their code.
Anyway, we did make it through that 4000% burst after some 524's so I think we'll be good to continue the sale.
- VirMachLink to comment