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....
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 ]
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 ]