• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mySQL, MS access, Oracle ...spec question

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
guys,

Say I have to create a database with the following spec:

500 users,
30 simultaneous connections,
All information in the db will be text and will not exceed 200Mb

What db should I use?

I�ve been using MS for a while and it worked great, however, I learned that mySQL is much more robust and FREE. As per Oracle � I�m not sure.

Anyone can help on this one?

"I�m the wonder�"
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65216
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While Access may be a great little personal database -- I used it quite a bit when I was still using Windows to keep track of personal data -- it is by no means production-capable. And, unless things have changed a bit, you will be saddled with the ODBC-JDBC bridge in order to use it from Java.

Free databases like MySQL and PostgreSQL (I use the latter for my commercial sites) certainly have the chops for the job.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic