I am contemplating a Big Project and have spent the day thinking about the architecture. That's pretty cool.

My current predicament has to do with whether I should present the page information (piped through the very cool HTML::Template) live from the database or just generate the pages using a daily cron job.

The advantages of doing it live: Pages are updated immediately, something that's fairly important for this application (yet another storefront). No cron job to worry about: immediate feedback as to whether changes are correct or not.

The advantages of using static pages: Page URLs are easy to nab -- therefore the web pages are easier to link to. Way lower load on the database (not that I think that's going to be a problem).

Hmm .. after listing those pros and cons, it seems the obvious way to go is live. Does anyone else have thoughts on this topic?

--t. alex

"Mud, mud, glorious mud. Nothing quite like it for cooling the blood!"
--Michael Flanders and Donald Swann