An expression in a WHERE clause makes an index unusable, and a generated column moves the expression into something indexable. The automatic substitution is the good part —…
Octane keeps the application in memory between requests, so a static property set during one request is visible to the next one — including one belonging to a…
A long-lived process holding thousands of connections is not what PHP is for, and a small binary beside it is a smaller change than a rewrite. Keeping the…
40ms becomes 8ms, and the fourth request returns another customer’s data. The shared-nothing assumption is load-bearing in more places than anybody had counted.
EXPLAIN shows the plan and the optimiser’s estimates, and the estimates are frequently wrong — a query planned for 40 rows that reads 400,000 looks entirely healthy. The…
Each condition in a meta_query becomes another self-join against a table that is usually the largest in the database. Modelling a filterable attribute as a taxonomy rather than…
5.7 added loading=”lazy” to iframes as well as images, and an embed without dimensions now reserves no space until it loads. The layout shift is the visible symptom:…