Page 1 of 1

Shoutbox Optimization: memcache?

Posted: Sat Mar 15, 2008 5:10 am
by Terriator
Hey,

I run a site that has a fairly much traffic; a few million hits / day. On this site, a form of "shoutbox" is used, where users chat with each other.

Unfortunately, this shoutbox isn't anything fancy; just an INSERT query each time a user posts something and then a while loop getting the last 10 rows from the mysql table.

This is draining my resources big time. Are there anyway I could optimize this simple shoutbox script?.. I've recently gotten memcache up and running on my servers, but I don't know how I'd go about altering the scripts to use this. If even possible?.. what should I do?

Regards