Hi,
I have web reports generated from a databse. Now, the way I figured is to
run one of the reports once adn saving the html out put to a file and any
subsequent querries made will be made to that file instad of requering the
database.
This will spead up the web report (millisenconds compared to 15 secs it
takes to generate my report) and lessen the load put on the database.
The thing I'm concerned about is when I do a system call (on a unix box) to
generate my file which will be my static report. Is this safe? Can bad
people do bad things if I release this?
My report consists of online registrations and summary numbers. Every time
someone pulls my web page up it make a about 10 querries to databases and
takes aprox. 7-15 seconds to generate and display. I love the idea of
generating the reult once and having all the rest of the people looking at
it from the output generated. It speeds things considerably..
My script does somthing like this..
If my date range is yesterday and the output file does not exist, it will
genereate it. If it is today it will go and query the database because
until midnight hits this report is always changing. Historical stuff (i.e
yesterday and before) is always static so quering the database is not
needed, unless my file does not exist.
Any ideas??
Hope you guys can unserstand my flipped up logic..
Thanks a lot in advance!
Gonzalo
_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
