Re: Separating static and dynamic contents?

On 7 Jan, 07:04, Gilles Ganault <nos...@xxxxxxxxxx> wrote:
On Sun, 6 Jan 2008 18:41:32 -0800 (PST), NC <n...@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?

If it's in the MySQL cache, yes.

If your pages don't change particularly quickly, you should be looking
at setting caching information via the header() function and using a
caching reverse proxy.

C.
.

Relevant Pages

  • Re: Separating static and dynamic contents?
    ... 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, ... MySQL won't actually have to compute it and access the hard disk? ...
    (comp.lang.php)
  • Re: Separating static and dynamic contents?
    ... 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, ... MySQL won't actually have to compute it and access the hard disk? ...
    (comp.lang.php)
  • Re: Problem with SQL and Recordset
    ... This assumes that the name of the subform control on the parent form is the ... NextSuffix field from the "query" to be entered into the Suffix field on ... Dim mySQL As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: [Q]Problems related to the MySQL linked Server.
    ... The error messge when I query data with following SQL. ... select @v_intUserNo = uno ... where userid = 'testid' ... I have two questions about the linked server for the MySQL. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Performance MySQL
    ... schicke erst den Query an die Datenbank ab, ... Möglichkeit von Concurrent Inserts nur MyISAM Storages ein. ... > MySQL bis jetzt noch nichts zu bieten. ... Welcher Tabellentyp? ...
    (de.comp.datenbanken.mysql)