Recently I noticed a long(ish) SQL query happening during checkout
The same calculation could be seen in the cart.

On the site, the SQL could take up to 2ms to process, thus adding unwanted delay to the end user experience

My investigations reveal a potential bug in how magento deals with quotes where no address has yet been selected.