Shoutbox Optimization: memcache?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Terriator
Forum Commoner
Posts: 60
Joined: Mon Jul 04, 2005 12:46 pm

Shoutbox Optimization: memcache?

Post 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
Post Reply