performance – Page 9 – Türker Yıldırım

A JSON column that had become a schema

Deep diveSeptember 20, 20239 min read

A settings column with forty keys, four of which are queried, and a WHERE on a JSON path scanning two million rows.

manualChunks, and a vendor bundle that was one library

NoteSeptember 6, 20232 min read

A 410 KB vendor chunk that invalidated on every dependency update, of which 280 KB was a date library used in two places. Splitting a rarely-used heavy dependency…

A benchmark that measured the benchmark

NoteAugust 24, 20232 min read

A microbenchmark showing one implementation four times faster than another, where the difference was the loop. Three separate errors in six lines: an unused result, a shared warm…

Moving a fifteen-year-old site into the site editor

Deep diveAugust 21, 202315 min read

A theme first written in 2008, 61 template files, and an editor who cannot change a footer without a deploy.

The N+1 that only appeared in production

Deep diveJuly 29, 202310 min read

An endpoint at 40 ms locally and 2.1 seconds in production. Nine hundred queries on one request, and three on the same request in a test.

MariaDB 11.0 and a new optimizer cost model

NoteJuly 18, 20232 min read

The 11.0 release rewrites the cost constants, which is a change that improves most plans and changes some of yours. A cost model change is the kind of…

Container queries, and the component that stopped needing a prop

Deep diveJuly 7, 202310 min read

A card with a variant prop that exists only to describe its width, rendered wrong in a sidebar somebody added last week.

Partitioning by month, and the query that scanned all of them

Deep diveJune 27, 202310 min read

A 400 million row events table and a delete that could not finish. Dropping a partition takes two seconds; getting there takes a schema change.

The image that was four megabytes because nobody looked

NoteJune 27, 20231 min read

A hero image uploaded at 6000 pixels wide, served at 1200, on every page load, for eleven months. WordPress has scaled large uploads down since 5.3 and a…

A cold cache after every deploy, and the warmer we wrote

NoteJune 22, 20231 min read

A deploy that flushes the cache produces two minutes of every request doing the expensive thing at once. A warmer is an admission that the cache is load-bearing,…