Re: hitting the limits

windandwaves wrote:
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?

An HTML page can perfectly be kept in the database, makes it even easier to
check wether a page has to be "rewritten" or not, possibly in 1 simple query
returning 0 or 1.

And if some items in a webpage aren't cachable, you could always try to
cache certain portions of code.

Grtz,
--
Rik Wasmus


.

Relevant Pages

  • Re: [FAQ] addslashes() and striplashes()
    ... How do I use addslashes() and stripslashes() when dealing with HTML ... Use addslasheswhen INSERTing or UPDATEing data into the database. ...
    (comp.lang.php)
  • Re: Virtual SBS server
    ... I have been posting in HTML since I became an MVP for SBS 5 years ago. ... With regard to Outlook over HTTP, it might be a bit faster since you don't have the VPN overhead to contend with. ... >>Depending on the database VPN may work, ... >desktop so making the server do all the work would be ...
    (microsoft.public.backoffice.smallbiz)
  • Re: following radio & hidden does not work..... help please.
    ... So you query the database for records and present the concatenated fname and lname for the user to choose from. ... This works the same with a radio button or a select statement. ... This is a HTML or PHP question! ...
    (alt.html)
  • Re: Photographs in British Naturism
    ... source code file, html, jsp, php or what ever), the only factor is ... not to the server if it's serving a html file, ... Currently, it's programmed to generate HTML pages from the text which operators have typed into the database through the admin interface. ...
    (uk.rec.naturist)
  • Re: GridView
    ... Dim cmd As New CommandField ... I tried to enter html text into the database table but that only ... I'm using a GridView to list data from a table in my database. ...
    (microsoft.public.dotnet.framework.aspnet)