MySQL has caching functions I believe. Read here: http://dev.mysql.com/doc/refman/5.0/en/query-cache.html Best regards, Peter Lauri www.dwsasia.com - company web site www.lauri.se - personal web site www.carbonfree.org.uk - become Carbon Free -----Original Message----- From: Martin Zvarík [mailto:mzvarik@xxxxxxxxx] Sent: Sunday, February 25, 2007 12:50 PM To: php-general@xxxxxxxxxxxxx Subject: PHP+MySQL website cache ? Yes/No Hi, I am making an eshop and I am thinking about caching system. You understand, that it cannot be entirely cached because visitor has it's own shopping cart etc. So, my thought is to cache only few blocks like "Categories", "Navigation menu" etc. by storing it to an HTML file. The advantages are that it doesn't have to query database and generate the HTML code again, but my question is: Is it good approach? Shouldn't we optimize database instead of restoring the data on harddrive? Thank you for ideas, Martin Zvarik -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php