Cotonti / Open Source PHP Content Management FrameworkContent Management Framework

Forums / Cotonti / Core Labs / Archive / Caching System Discussion

File Caching vs MySQL Caching

diablo
#1 2009-02-27 22:43
First of all i want everyone to read those

http://www.mysqlperformanceblog.com/2006/08/09/cache-performance-comparison/

http://jpipes.com/index.php?/archives/100-Benchmarking-CacheEngine-vs.-the-MySQL-Query-Cache.html

http://74.125.67.132/translate_c?hl=tr&sl=tr&tl=en&u=http://www.kodaman.org/yazi/cache-proxy-web-ustunde-yuksek&prev=hp&usg=ALkJrhhXLoRYwjz7cSXuNspw2PxQj3BYcw
last one is translated by google translate

File Cache :

If your data is not updated much and your site has static data as majority this cache system is for you.
Pros:
- Better Performance
- Good for pages which dont get edited for long time
Cons:
- Slower when updating the data
- not suitable for multi-server sites

MySQL Cache:

Pros:
- Faster
- Good for pages updating much
Cons:
- not good for mass user communities
- unnecessary server load for old pages
"Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live."
Lombi
#2 2009-02-27 22:50
Kilandor and I have a fully running MySQL caching system (bypasses the entire generation of the page block if turned on thus effectively nullifies any load that's page related). The speed increases and load decreases are ... well, amazing.

(tested on 350.000 page portal, dropped load down two times, sped up site by 100%)

We call it supercache.

Can release it.
<a href="http://www.domenlo.com">Surreal Art</a>
Kilandor
#3 2009-02-27 23:31
Me and trustmaster have Discused the future caching system, we will likely have 3 methods, and Improved more event driven cache also, a Typical SQL Cache, an optional SuperCache, along with Optional FileCache. And the admin can pick the type of cache they want
Lombi
#4 2009-02-28 03:01
That sounds awesome.
<a href="http://www.domenlo.com">Surreal Art</a>
Trustmaster
#5 2009-02-28 04:00
Don't forget about memory cache.
May the Source be with you!
tensh
#6 2009-05-15 22:01
Are there any plans for a release of caching system soon?
Lombi
#7 2009-05-15 22:13
It might be in 010 but the file caching isnt implemented/tested yet (while mysql caching is working on pages and not of forums). So still quite a long way to go.
<a href="http://www.domenlo.com">Surreal Art</a>