PHP cache mysql or complete html?

Question

worth the set cache html code or just mysql (serialize)?

the full HTML should reduce load time without re-implementation of the php script if I'm wrong. Do you know of some other disadvantages?

//Use html to serialize cache or another option?

cache invalidation is really not trivial task.

mkk
– mkk

2012-03-02 14:17:21 +00:00
Commented Mar 2, 2012 at 14:17 — mkk
– mkk, Commented Mar 2, 2012 at 14:17

Martin Rothenberger · Accepted Answer · 2012-03-02 14:42:01Z

2

Nothing is faster than plain HTML pages, so go for both cache solutions. But as Alfred said, you should use APC instead of MySQL as serialized cache. Also, you should take advantage of the MySQL query cache.

Further on, checkout memcached and/or Redis as alternative for storing values which need to be stored and retrieved very often.

EDIT: Just another idea to gain more performance - store your HTML files using a tmpfs (RAM based) filesystem. If something is faster than pure HTML files, then it can only be pure HTML files served via RAM disk. ;)

answered Mar 2, 2012 at 14:42

Martin Rothenberger

8285 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pater SVK Over a year ago

I have written custom code to cache the files, only to decide whether to review and I do not use another option. Needs fast cache queries or complete html code.

Martin Rothenberger Over a year ago

Then just put the files onto a RAM disk (tmpfs). Cannot be faster.

Peter Cetinski · Accepted Answer · 2012-03-02 14:21:50Z

2

Use both. HTML caching is critical in high-volume PHP sites.

answered Mar 2, 2012 at 14:21

Peter Cetinski

2,33614 silver badges8 bronze badges

Comments

Alfred · Accepted Answer · 2012-03-02 14:29:09Z

0

You should set expire headers on all your assets. Furthermore if possible use APC instead of mysql cache. If not possible to use APC, then you could use MySQL query cache like you said(I assume you meant this), but it is not as solid as APC.

answered Mar 2, 2012 at 14:29

Alfred

62k33 gold badges151 silver badges186 bronze badges

2 Comments

Pater SVK Over a year ago

APC is faster than the file cache?

Alfred Over a year ago

it is, because then you will avoid disc io. APC uses RAM

Collectives™ on Stack Overflow

PHP cache mysql or complete html?

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related