A query answering in 20 ms locally and timing out on four million rows. An anonymised data subset that keeps the query plan honest, and the mail, cron…
Three developers, three PHP patch versions and a bug that existed on one of them. A Vagrantfile, a playbook for everything inside it, and what the rebuild costs.
Every project acquires a logger and every one of them is shaped slightly differently — log($message, $level) here, error($message) there, a static call in the third. PSR-3 fixes…
A slow query log at the usual one-second threshold shows the report that takes four seconds and hides the nine hundred queries of eight milliseconds that the product…
A daily report scanning 1.2 million rows to return two hundred. Why neither obvious index helped, what the composite one costs, and the two answers I turned down.