Re: PHP+MySQL website cache ? Yes/No

I know it does, but I think it is still faster to include a generated HTML file than query a database. But is it worth the miliseconds? --- Peter Lauri napsal(a):

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@gmail.com] Sent: Sunday, February 25, 2007 12:50 PM To: php-general@lists.php.net Subject: [PHP] 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