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
SCJP, SCWCD, SCBCD, Oracle Certified Professional (SQL n PL/SQL)
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 ...
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.