Re: [PHP] PHP+MySQL website cache ? Yes/No

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@xxxxxxxxx] Sent: Sunday, February 25, 2007 12:50 PM
To: php-general@xxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)