Re: Separating static and dynamic contents?

Gilles Ganault wrote:
On Sun, 6 Jan 2008 18:41:32 -0800 (PST), NC <nc@xxxxxxxxx> 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@xxxxxxxxxxxxx
==================

.

Relevant Pages

  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • Re: query parameters at the end of the JavaScript file
    ... information in the query is a version number. ... Browsers are not supposed to cache GET requests with queries AFAIK. ... Are you aware of any browser that doesn't cache a GET request? ... search engine on the web due to overload on the server of constantly giving the same search out. ...
    (comp.lang.javascript)
  • Re: Error executing version of Net Framework
    ... ** postback the page whenever a user select a item in listbox and query the ... Also, for server-side caching, are you using the ASP.NET Cache storage? ... server machine, however, we have to make the choice whether we should ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Should Cache be on the MV Family Tree?
    ... >> Will the Cache' product have functional DataBASIC or multivalue query ... the query language at a directory of XML documents? ... I took a look at the web site and see MultiValue BASIC as the ...
    (comp.databases.pick)
Loading