[RESOLVED] Caching Multiple Pages

fr600

Hello,

I've created a basic news board script and I want to enable caching to reduce number of queries. I know how to cache a single page after every xx minutes but I don't know how to cache multiple pages (with pagination). Any idea how to do this?

Thanks

kubis

fr600 wrote:
Hello,

I've created a basic news board script and I want to enable caching to reduce number of queries. I know how to cache a single page after every xx minutes but I don't know how to cache multiple pages (with pagination). Any idea how to do this?

Thanks

it depends on what you exactly need

do you want to cache the whole page, included the dynamically generated content?

then write a script that creates .html pages and run it regularly, say every 10 minutes.

if you need to cache the PHP scripts, try some caches, like APC, eaccelerator etc.

if the database is a bottleneck, try to run some maintenance, like optimize /vacuuming, set up some indexes or examine the query-plane if all queries uses correct indexes

fr600

I don't have permission to use apc or eaccelerator on the server. So I'm using this: http://www.developertutorials.com/tutorials/php/php-caching/page1.html

But you know, the problem is it cannot cache multiple pages (or dynamic site). Any idea?

Thanks for you help

kubis

fr600 wrote:
I don't have permission to use apc or eaccelerator on the server. So I'm using this: http://www.developertutorials.com/tutorials/php/php-caching/page1.html

But you know, the problem is it cannot cache multiple pages (or dynamic site). Any idea?

Thanks for you help

set up some proxycache (like squid) in front of the server and give to all the output scripts expiration headers in the future.

first access:
web visitor ---> HTTP request --> CACHE --> webserver --> CACHE (now the result is being cached for some time according to expiration headers) --> HTTP response --> web visitor

next accesses until the time() > expiration header

web vistior --> HTTP request --> CACHE --> HTTP response --> web visitor

but i think if you aren't able to enable some module, you wont be able to establish a proxycache either

fr600

kubis wrote:
but i think if you aren't able to enable some module, you wont be able to establish a proxycache either

Yes : (

Roger_Ramjet

You can speed up execution by caching the queries as well. http://dev.mysql.com/doc/mysql/en/query-cache.html

fr600

Thanks