Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Pre-processing PHP/mySQL into straight html.

2:20 pm on Jun 5, 2006 (gmt 0)

New User

5+ Year Member

joined:Mar 28, 2006
votes: 0

Using PHP/mySQL to do multiple accesses to large tables uses a lot of resources when getting many concurrent hits. As others, my sites have dynamic data that changes sporadically, bi-hourly at best.

Here is the question:

Has anyone used file_get_contents & file_put_contents (or similar) to pre-render and save the straight HTML as the actual delivered pages?

This would save tons of PH and mySQL processing, speed up delivery and could be run as a CRON.

Any input would be useful.

3:43 pm on June 5, 2006 (gmt 0)

Preferred Member

10+ Year Member

joined:Apr 30, 2005
votes: 0

There are a multitude of caching solutions available - it is hardly worth bothering trying to "roll your own"

If your data is not that dynamic, then a query cache (built into MySQL for example) will help if you have lots of identical queries being used, and a PHP cache like APC will help with PHP performance.

5:07 pm on June 5, 2006 (gmt 0)

New User

5+ Year Member

joined:Mar 28, 2006
votes: 0

There should be a new Murphy's Law:

The answer to your question will become immediately evident upon posting in a public forum.

Picked up PEAR Cache-Lite.
Using Output.php to cache complete pages indefinitely.
CRON jobs update underlying tables and delete the appropriate cache files.


(0.01 sec to render, 0.005 sec. from cache)


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members