spam and site hiccup
I killed another spammer's account this afternoon. While cleaning up the mess he made I noticed an inefficiency that I think has been the main issue behind some of the slow page loads here. My first attempt to fix it briefly locked up the site, but my second attempt appears to have gone smoothly.
I've eliminated a database query that was happening on every page load. I don't see it causing any problems, but if you experience any weirdness please let me know.