Re: PHP+MySQL website cache ? Yes/No

Martin Zvarík wrote:
I did a benchmark with and without caching to HTML file and it's like:

0.0031 sec (with) and 0.0160 sec (with database)

I know these miliseconds don't matter, but it will have significant
contribution in high-traffic website, won't it?

I would say yes. A good caching system is essential in a high traffic
system.

Ideally you'd allow very fine control over what "blocks" are cached and
for how long with automated system for extending the life of the cache
if the hosting environment is being hit hard.

e.g. autodetect high load and make the cache last for 1h rather than 5 mins.


I think you are on the right tracks to design this in.

Col
.

Relevant Pages

  • Re: Idea about a disc backed ram filesystem
    ... caching system that the kernel already applies to reads of all block ... devices, other than essentially locking the cached data into ram, rather ... True, my idea is indeed similar to the existing cache, thats why I had one of the ... If you ever had the possibility to run a database application on a tmpfs you got ...
    (Linux-Kernel)
  • Re: APC cache performance
    ... dependant on the speed it can be build in the first place, and your exact ... caching system. ... But I have tested APC cache against some ...
    (comp.lang.php)
  • Re: Need prog. to prevent hdd going into idle (such as a perdiodic access?)
    ... no caching system is able to cache a 1.5 GB file with only 512 MB ... RAM. ... there's some kind of error message. ...
    (comp.sys.ibm.pc.hardware.storage)