Progress today: memcache, MySQL and CherryPy

I’ve been able to spend the whole day on Fab Swingers which has been great.

First off, I’ve written a trivial CherryPy tool which logs any slow pages. Currently “slow” is defined as 500 ms but I’ll need to cut this back a bit.

This tool has already been quite handy and I’ve spotted two missing database indexes which has already dramatically speed up the Cross-dressing page.

I’ve also implemented memcache for the homepage, the profile pages, the session system and for the new mail received prompt. As a result MySQL has dropped right down in CPU usage.

Leave a Reply

You must be logged in to post a comment.