aspose file tools*
The moose likes Servlets and the fly likes database-driver website Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "database-driver website" Watch "database-driver website" New topic
Author

database-driver website

Karim zibari
Greenhorn

Joined: Aug 19, 2005
Posts: 6
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?

akz
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

Any particular reason why you want to store everything in a DB ?


[My Blog]
All roads lead to JavaRanch
Karim zibari
Greenhorn

Joined: Aug 19, 2005
Posts: 6
i plan to store everything in a db to make the site as dynamic as possible.
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 666
It may be a good idea to store the index of all articles in DB. Then you can locate the articles using the index and redirect to the real articles on the fly.


BJ - SCJP and SCWCD
We love Java programming. It is contagious, very cool, and lot of fun. - Peter Coad, Java Design

Crazy Bikes created by m-Power
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: database-driver website
 
Similar Threads
Record level locking
caching so that the website is available for the user??
How to increase performance of website written in JSP/Servlet?
gps week/seconds conversion
Hibernate with MySQL Full text search