[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    Re: [PHP] PHP+MySQL website cache ? Yes/No
From:       "Richard Lynch" <ceo () l-i-e ! com>
Date:       2007-02-27 23:42:25
Message-ID: 54906.216.230.84.67.1172619745.squirrel () www ! l-i-e ! com
[Download RAW message or body]


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@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
>>
>
> --
> 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

[prev in list] [next in list] [prev in thread] [next in thread]