Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Re: pulling content from db - is it a good idea?

by inman (Curate)
on Nov 25, 2003 at 12:23 UTC ( [id://309871]=note: print w/replies, xml ) Need Help??


in reply to Re: pulling content from db - is it a good idea?
in thread pulling content from db - is it a good idea?

The last option is particularly useful if the HTML page produced only changes once a day but the length of time that the script takes to run is long or consumes many resources.

An example would be if the web page showed a daily status report derived from a number of processor intensive SQL queries. The same script (using CGI and HTML::Template) can be scheduled to produce a fresh static HTML page on a daily basis.

inman

  • Comment on Re: Re: pulling content from db - is it a good idea?

Replies are listed 'Best First'.
Re: pulling content from db - is it a good idea?
by Abigail-II (Bishop) on Nov 25, 2003 at 12:27 UTC
    I'd say that even if the content changes every five minutes, it's in most cases worthwhile to generate a static HTML page every five minutes. About the only time where that's a bad idea is if all of the following are true:
    • Generating the HTML page consumes a lot of resources.
    • You get less than one hit on the index page every five minutes.
    • The server is busy doing things other than serving the index page.

    Abigail

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://309871]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others perusing the Monastery: (10)
As of 2024-04-18 08:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found