| Author |
MySQL and Servlets
|
Micky Pat
Greenhorn
Joined: May 03, 2006
Posts: 18
|
|
Hello World,
I am new to this website, even if I spent some time reading the posts... VERY interesting.
Straight to point: I would like to develop a website with some capabilities of storing and retrieving data from a database. Is MySQL a good/easy option? Can I expect significant worsening in performance if the database is too big or if I start too many users?
Any other idea? Sorry for the fuzzyness of the question, I am still browsing the Servlet/JSP world....
|
 |
Bear Bibeault
Author and ninkuma
Marshal
Joined: Jan 10, 2002
Posts: 56157
|
|
MySQL is a popular choice for a web app DB, as is PostgreSQL. Naturally, there are issues around large databases and heavy bandwidth, but those are issues that DBs are built to deal with.
[ May 04, 2006: Message edited by: Bear Bibeault ]
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
|
|
Micky Pat
Greenhorn
Joined: May 03, 2006
Posts: 18
|
|
Hi Bear,
so I can start building my webapp without being afraid of future scalability....
|
|
Bear Bibeault
Author and ninkuma
Marshal
Joined: Jan 10, 2002
Posts: 56157
|
|
Sure. Be sure to use best practices such as connection pooling, as well as architecting your web app using an n-tier model, segregating all DB access behind a model facade (in other words, NO db calls in the servelts and JSPs).
[ May 04, 2006: Message edited by: Bear Bibeault ]
|
|
Bear Bibeault
Author and ninkuma
Marshal
Joined: Jan 10, 2002
Posts: 56157
|
|
|
This article may be of interest with regards to web app structure.
|
|
Micky Pat
Greenhorn
Joined: May 03, 2006
Posts: 18
|
|
Ok, I will investigate on that.
Thank you very much
Michele
|
|
 |
|
|
subject: MySQL and Servlets
|
|
|
0
