The Journal

Writing on Databases.

Practical writing on web development, WordPress, Next.js and the business of getting websites right.

1 article

Databases29 October 20267 min read

Why wp_postmeta Gets Slow, and What Actually Fixes It: A MySQL Benchmark

2.3 million wp_postmeta rows, the exact SQL WP_Query writes, and four fixes. One index made a lookup 500× faster. Another made a query 3× slower.

Whether it's a new website, a redesign or something more ambitious, let's put some numbers around your idea.