Re: hitting the limits

Rik wrote:
....
To decrease server-load you could think about a cache system: review
the dependancies of databasefields for each of your pages, create
appropriate timestamps with an index in the database if they don't
exist already, and cache the pages locally as html with a date/time.
On a request, check wether there is a timestamp in the database
higher than of your cached html If not, serve the cached file, if so,
create new cachefile and serve that. Creating of cachefiles should
offcourse take place automatically on an update of a certain database
field, but that might be even more work.


Rik, that is a cool idea, would you just place the html in a database or is
there a special chache where pages are kept?


.

Relevant Pages

  • Re: ANN: Sequel 3.4.0 Released
    ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ... A timestamps plugin was added for automatically adding ... There are three different timezone settings: ...
    (comp.lang.ruby)
  • ANN: Sequel 3.4.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... A timestamps plugin was added for automatically adding ... There are three different timezone settings: ...
    (comp.lang.ruby)
  • Re: inserting data from resultset into oracle database - but not inserting in correct order
    ... particular table in a SQL server database, ... ResultSet, and then inserting that data from resultset into an oracle ... So I basically select a range of data between 2 timestamps. ...
    (comp.lang.java.databases)
  • Re: inserting data from resultset into oracle database - but not inserting in correct order
    ... particular table in a SQL server database, ... ResultSet, and then inserting that data from resultset into an oracle ... on timestamps. ...
    (comp.lang.java.databases)
  • Re: hitting the limits
    ... appropriate timestamps with an index in the database if they don't ... and cache the pages locally as html with a date/time. ... check wether there is a timestamp in the database ... Rik Wasmus ...
    (comp.lang.php)