Dynamic content and the whole database thing

[Brett_Tabke]

Anyone running a website out of a database? Which one are you using and how well is it working?

I'm considering throwing this whole site (the entire thing, every scrap of content) into a MySQL database and just serving it out of there via custom perl. My fear is that it would be too slow and also too difficult to backup. I've got a semi working prototype running locally but it is slow on my machine (4seconds mandatory overhead per page). On the webserver here I feel it would be a bit faster.

Any thoughts?

[Nick]

It's a good idea to run your site froma database, you can pull out info and use it in different context's and it will serve you well as the site grows. Continous updates are easier to do as are site-wide changes (headers etc.).

The problem with speed is normally solved using PHP3 when working with MySQL, another solution could be using eperl, I recommend www.hotwired.com for details.

If you are really persistant about using PERL, you could solve speed issue by installing mod_perl, avoiding forking a new process each time a perl script is called...

Hope this helps,

N