Boz, I currently develop web server applications and I agree there's
a big temptation of having everything dynamically generated while
you simply maintain the database. However, you should seriously
consider the impact on the server load. The number of hits KMP
currently faces will roughly translate to as many server processing
rounds. You may come to a point where the processing power and not
bandwidth is the bottleneck. If you rarely update the database, you
don't need redundant generation of the same pages. Your "historical"
site hardly requires real time update. ;o) Off line page generation
may be a better idea. Photodo came sometime ago to the same conclusion
and gave up to dynamic access together with its goodies - sorts,
comparisons, etc.
As for volunteering... well, maybe later this year..
Servus, Alin
Bojidar wrote:
BD> Hi folks,
BD> I have finally decided to take the next step and upload the entire KMP
BD> data into a database (probably MySQL). Initially I will be generating
BD> the HTML pages "off-line" (probably using Perl) and then uploading them
BD> to the web. When all that works well, I will be tempted to put an SQL
BD> interface to the various tables.
BD> Has anyone done simlar things? I am not very familiar with MySQL and
BD> Perl, but I am familiar with databases and scripting languages in
BD> general.
BD> In the meantime, I have given up on the idea to do everything in HTML or
BD> XML because of the lack of consistent browser support for these
BD> languages. However, when all the data is in a database, producing
BD> anything that I want will simply be a matter of changing a few scripts.
BD> So, are there experts who can comment on this idea? Second, are there
BD> volunteers who will help me type the data into the database (or first in
BD> Excel and then I will convert it to a database format)?
BD> Thanks and cheers,
BD> Boz
-
This message is from the Pentax-Discuss Mail List. To unsubscribe,
go to http://www.pdml.net and follow the directions. Don't forget to
visit the Pentax Users' Gallery at http://pug.komkon.org .
