dsandler.org/wp

(There we go, blowing my whole bang-quota for today, just in the title.) So, all this fancy tagging is placing a non-trivial load on the DB; typical page generation takes about 4 or 5 seconds, which really sucks for a front page.

Staticize to the rescue.

I built a similar on-demand page caching system like this for the old, slow dsandler.org to improve the performance of several thousand calls to stat(), but I was surprised to need it for WordPress.

Fortunately, I’m pretty sure it’s not WP in general, but the tags, causing the performance issues, because the post-metadata tables aren’t indexed at all. SELECT ... FROM wp_postmeta WHERE meta_key = 'tags' is a comb through the whole table, every time. (I wonder if WP would break if I put an index on meta_key.)

So, just as proof that Staticize is doing its job:

<!-- Dynamic Page Served (once) in 9.289 seconds -->
<!-- Static Page Served in 0.275 seconds -->