Re: PHP+MySQL website cache ? Yes/No

Hi, If you able to access memcached. Use memcached. Put your shopping chart items, rendered html items in memcached. It was MUCH faster solution... Regards Sancar On Sunday 25 February 2007 13:59, Martin Zvarík wrote: > This benchmark is not very accurate, but you are right the database > connection took most of the time. > > Shopping cart is stored in session - not in database. > > I am half-way doing the eshop I bet it will took much more than 0.01 sec > to generate the final version. > > I was going to make this file cache system, but I relies that for each > page like (?page=News, ?page=Products etc.) these HTML blocks > (Navigation, Recommended) changes and that would mean I would have > eventually like 50+ cached files. > > One way or another I will always need to connect do database (I cannot > cache 300 products in 300 files, can I?). So I decided to put the cache > in database table - For each URL Name (news/, products/ etc) a Cache > (which will be an array of all HTML blocks). > > Martin > > lists@dwsasia.com napsal(a): > > Quoting Martin Zvarík <mzvarik@gmail.com>: > >> I did a benchmark with and without caching to HTML file and it's like: > >> > >> 0.0031 sec (with) and 0.0160 sec (with database) > >> > >> I know these miliseconds don't matter, but it will have significant > >> contribution in high-traffic website, won't it? > >> > >> Martin > >> > >> --PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > > > > Yes it will. And the 0.0129 seconds extra most of it is maybe to create > > the DB connection. Or are you using a persistent connection and reuseing > > it? > > > > This benchmark was that together with all other content of the page? I > > mean including your dynamic shopping cart etc? > > > > /Peter > > > > --PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php