MemCache or APC to reduce MySQL Queries

[n1concepts]

Q: Anybody got info to show how to setup caching (php scripts) to reduce having to perform MySQL queries on each HTTP request - being alot of the data is unchanged?

 

I need to cache this info which will eliminate about 80% of 'repeat' queries to a db that's under constant load.

Any info to help define this process appreciated - thx!

[n1concepts]

Found afew examples - this will do what i need:

http://papermashup.com/using-memcache-with-php

http://dev.mysql.com/doc/refman/5.1/en/ha-memcached-interfaces-php.html