Posted by Jerry Stuckle on 01/07/08 12:52

Gilles Ganault wrote:
> On Sun, 6 Jan 2008 18:41:32 -0800 (PST), NC <nc@iname.com> wrote:
>> It's not; you are confusing caching content with caching database
>> queries.
>
> Thanks for the clarification.
>
>> If you cache queries, you simply turn on query caching in the MySQL
>> server; no specific calls from the application are necessary.
>
> Am I right in saying that MySQL doesn't care from which web user the
> query is coming: As long as it's in the DB cache, ie. it's a query
> that is often made from web user, regardless of who they are, it will
> be sent to the PHP process, significantly improving performance since
> MySQL won't actually have to compute it and access the hard disk?
>

That is true. The same query will just return data from cache. Just
like if two processes read the same file, the OS will return the data
from cache on the second request.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]