i am designing a dynamic website for a local newspaper. i plan to store all the sites content in a MySQL database inculing articles, pictures, thumbnail etc.
i've read that this solution (using a database for all content generation) is an overkill and would significantly undermine the site's responce times and efficiency. even the site's links are all dynamically generated from the database.
i am using html, jsp, servlets and classes to access MySQL. any ideas?
The database might be good if you're going to let site users write content. Maybe give them an editing page and save what they write to the database. The database isn't required even for this kind of thing. You could write the content to flat files and just use the database for some kind of indexing and organizing. When you're that dynamic you're into "content management system" territory. You might Google around on those just to become familiar with the kinds of things they do and see if you want to use an existing one or implement some similar features.
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi