chyrp is a nice
looking piece of blog software. individual posts can have
different styles, something it borrowed from the hosted tumblr service. i was
interested to read about “the sql query massacre of january 19th, 2008”
but the numbers gave me pause — 21 queries to generate the
index page? that is down from an astounding 116, but that still
seems ridiculous to me.
the number of queries to generate the index of this site? two.
one of them is SET NAMES utf8
. i could see boosting
that to three or four if i moved some things like the list of
links in the sidebar into the database, or added archive links.
call it five if i had user accounts.
but right now, the number of queries used to load the index page …
Showing entries 1 to 1
Feb
27
2008
Showing entries 1 to 1