We have often seen that the loading of some sites with heavy data retrieving from database are become late 1-2 sec. and sometimes it is upto 5sec. also. So the main problem is execution of sql query each time.
Here is a concept of creating some intermediate files i.e. *.cache files such that the files generated for the first time and for the consequence times it shows result without executing the whole sql query.
I know this may be a little bit difficult to understand at the first time but it is easy and you can learn it soon. I have taken php to create the code and database used is mySql. The example is from osCommerce code.
I hope you will enjoy this.
So here you can start...
Click to see the post
