The problem

During a recent audit of our Magento storefront we noticed checkout performance was degrading when tax calculations were performed. Using NewRelic APM we traced the slowdown to a classic query‑in‑a‑loop anti‑pattern.