Your cart and all that has to open a DB connection anyway. Unless you do something horribly wrong in DB design, running one more simple query is CHEAP once you pay the price of making a connection. Benchmark it on your hardware and find out. On Sun, February 25, 2007 5:06 am, Martin Zvarík wrote: > 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@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 > > -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
