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
Shoutbox Optimization: memcache?
Moderator: General Moderators