Turbocharging Site Speed… With Taxonomies
summary
Using taxonomies instead of post_meta for flags and sections cuts expensive meta queries (which build temporary tables) and often runs orders of magnitude faster on sites with thousands of posts. The process uses a register_taxonomy generator to create a private taxonomies setup (public = false, show_ui/rest = true), registers utility taxonomy terms for “show on homepage” or featured areas, and hooks term assignment on publish. Migration happens via a one‑off WP‑CLI batching script or local rewrite to convert existing post_meta into terms.
AI-written summary · about
chapters (20)
- 0:00Introduction to taxonomies
- 1:09Why use taxonomies for speed
- 2:13Generating taxonomies easily
- 3:17Public vs private taxonomies
- 6:10Utility taxonomies for internal use
- 8:18Hiding posts from homepage
- 12:57Automating taxonomy assignments
- 14:48Featured areas and sliders
- 18:59Hierarchical vs flat taxonomies
- 21:34Migrating existing post meta
- 24:06CLI commands for migration
- 26:17Removing taxonomy terms
- 27:01User-friendly taxonomy labels
- 29:10Handling negative queries
- 30:17Why taxonomies are faster
- 32:02Trade-offs in taxonomy design
- 34:58Optimizing WP_Query further
- 36:49Database query efficiency
- 38:15Decision timing for performance
- 38:43Q&A
