Hi folks, please humour me with this slightly OT RFC...
So I've re-invented the wheel (or MVC framework) and need to make it
efficient. A high-traffic site is using the system and is causing me
some grief...
Some questions have come up re efficient caching:
- MySQL caches compiled statements, so why should I bother using
prepare/execute?
- if MySQL's cache is very efficient, should I bother caching in my own
code?
- is there any merit in keeping the httpd process size lower by relying
on MySQL or another inter-process cache?
Advice/flames/advocacy welcome ;)
cheers
John