re: reducing the size of the db by moving the attachments to the filesystem

this is gotta help but even at half a gig, doesn't it all fit in memory anyway (assuming the server's got the "standard" min of 1 gig)? Or is the bottleneck the number of concurrent processes?

If you need a mysql test box, I've got it running here.

re: client update of stats.

using rtorrent (0.2.4) which can manually update to the tracker. neither manually updating nor using "cancel" nor using "pause" works. I'm sure a fix for rtorrent is not a high priority but just so you know. i'm upgrading to 0.2.6 within the next couple of days and if things change, i'll drop a note.