Moore Powerrrr!

As the popularity of the scrabble cheat-o-matic has grown, so have the demands on the server this website lives on. While it's a fairly meaty machine (2.8 GHz P4), for the last couple of weeks it's been running with a load of over 2 and an average CPU usage during the 'day' of 60% - and this has been steadily climbing. Another few weeks of growth and it'd be in trouble.

Throwing more hardware at the problem was an option, but hey - I am supposedly a computer scientist...

Tonight, I finally sat down and got round to fixing it from being the dirty hack that it started as - this is the second set of performance improvements and they definately seem to be worthwhile:

CPU graph

Average query time is down from 2.4 seconds to 0.08 seconds. I do have further plans for the cheat-o-matic, but I think that's enough for one day. Watch this space for more!

Contact: site@spod.cx