Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

why MS access not good ?

 
Rajeev Ravindran
Ranch Hand
Posts: 455
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
For an web application I heard MS access cant support more than 10-15 users, but oracle and other RDBMS packages supports n number of users.. Could any1 tell me why access has this drawback ???
thanks
raj
SCJP
SCWCD
 
Tiberiu Paun
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm sorry to inform u that Oracle doesn't support more than 20-from what I know users simultanuously. It's not oracle's fault, but oracle driver's fault.
I know I made a JDBCConnection pool for oracle, and when I configured it for 20 users, it thrown me an exception with this topic.
However, u should use anything else but MS server. Try MySQL, is better.
We have a lot of applications, all of them do heavy selects in Oracle databases, none with the slightest problem.
The only application which uses MS SQL server has problems. And the database of it has only one table!!!
So if you use MS, than u r in trouble ...
 
Dana Hanna
Ranch Hand
Posts: 227
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
WOW - that last post is full of bold statements.
Oracle supports thousands of concurrent users!
MS Access has problems based on the fact that it is very lightweight, and is a single file implementation. The ODBC driver tries to take care of this, but the database implementation in general is not meant for large scale enterprise applications.
MySQL is a great choice, and the new control center makes it great for newbies.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic