PhP Caching - webmaster forum

Introduction

In this article I will try to give a view of what is the custom caching with php, why and how we can use it.

In the modern days, most of the sites are database driven. That means that your site is actually an application which retrieves data from a DBMS ( database managment system, eg MySQL) , parses the data and shows the result to the user. Most of these data are usually don't change frequently or don't change at all, and the reason that we use the database is that we can easilly update the site and the content.

A problem that this process creates is the server overhead. Every time we execute a query in the database, the instance of our script will call the DBMS, and then the DBMS will send the results of the query. This is time consuming, and especcially for sites with heavy traffic is a real big problem.

How we can solve this problem?

There are two ways to solve this if you want to make your site faster. First is optimizing the queries , but we will not talk about this at the present article. The second and most valuable is using some kind of custom caching technique.

Custom caching with php

First let me explain the idea behind custom caching. When we have dynamic pages that their data is not updated frequently, we can use a 'system' that will be able to create the page, and then store it for later use. That means that after the page's creation, our application will not run the queries again in order to display the page, but it will show the cached one. Of course this system must be able to keep the cached pages for a time period that we will set.

Let's code it

Here is a simple class that will do the job. Let's see the code first :


Now let me explain :

function cache()

This is the constructor function of the class. The job of this function is to check if there is a cached file for the page that we want, or it should create it. Here is how this is done :

$this->file = $this->cache_dir . urlencode( $_SERVER['REQUEST_URI'] );

This line creates the file name of our cached page. So the cached file will be something like /path/to/cache/dir/request_uri

if ( file_exists ( $this->file ) && ( fileatime ( $this->file ) + $this->cache_time ) > time() )

Here we check if there is a cached version of this page, and if the file must be recreated because it has expired. If the file is cached, it will show the cached page and the exit. I will explain later why  exit. If the cached file must be created this code will be executed :

$this->caching = true;
 ob_start();

The first statement indicates to the close() function that it is creating the cache file, and the ob_start() will start buffering the output. The buffer's data will be used later by the close() function to save the cache file.

function close()

This function must be called from the end of your script, and it will do the rest of the job. Actually it is needed only when we are in the process of caching that's why it starts with the statement  if ( $this->caching )
Let me explain what is happening here :

$data = ob_get_clean();

Here we get all the data from the output buffer while we unset it, and put the data in the $data variable. The four statements that folow up are showing the data and then write the cache file.

Troubleshooting

This is a very simple class, and the purpose is to learn how you can implement a caching solution for your site. The obligation using this class is that you must use it only in this form :


If you have code after the $a->close() statement, the class will not work right. This is because of the exit() statement in the cache() function.

Of course you can take this code and make it work for your own needs.

A quick solution is to remove the exit() statement in the cache() function and then use the class this way :



Hope this helped.


You can publish this article to your site, but only if you give back credit, and a link to http://www.webdigity.com/

I can see this being very useful on very busy pages that don't change often at all. I will remember that your script is here for later when I need it...

I have this sql query that takes around 30 sec to complete. The query searches through 40000 clients and is very complicated; I wish that I could use this caching here, but I can't bacause the data is consantly changing. Sometimes you can't optimise your queries anymore...

That's true. But you can propably optimize the DBMS. The bad thing is that I don't know much about this as I am working only with the coding issues.

I will try to convice my admin guy to write an article about this.

I suppose a lot of people would be interesting on that.

I am sure too!

For me at this stage I think that the best is to use LIMIT's in the query to shorten the search time.

Very nice article, and thanks for the clean code!

I had a little difficulty getting this to work until I changed the call to fileatime() to be filemtime().  That way you use the "modification time" instead of the "access time".  I am on FreeBSD, not sure if that makes a difference.

cheers,
James

yeah I remember that some machines make a difference in this ...

Interesting. I think this is only for BSD based os. If you use the access time on windows it will give you the last time someone read the file

very nice, thanks man, I'll c&p to my snippets file for a good look at, and use of later.

There are sites that will help YOU analyze your system, but don't let them do it for you. I've listed such a site below. They have links to volunteer sites that will help you clean your system, and somewhere along the line they will ask you to send them a log of what's going on with your system. They will use that to analyze your system and will give you advice based on that. That's safe. Don't let them have direct access to your system, however.