Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Unanswered: Deciding on Database

    I am developing a web based application, and I am expecting lots of users accessing the site simultaneously. I would like to know which database should i go for, SQL Server, ORACLE ,MySQL or any other db would suffice. The number of people I am expecting to be accessing simultaneously would be around 1 million users. It would be great if anyone can help me on this. Thanks

  2. #2
    Join Date
    Mar 2002
    Reading, UK
    I'm probably slightly biased but the main difference between oracle and sqlserver, db2 etc is in the way it locks and the multiversioning capability of oracle. To put it simply oracle seems to have been designed for the worst case scenario of loads of users all accessing the same data, sql server and most other databases seem to have been designed for the best case scenario of few users not accessing the same data. Other than that functionality wise there isnt much difference though cost wise Oracle is a bit more expensive.


  3. #3
    Join Date
    Oct 2003
    IF you have potentially 1M users, you figure for peak periods 20% hitting the app at the same time, and 20% of those hitting the DB at the same time. So, 40,000 DB threads to handle simultaneously. That's a serious bandwidth issue to handle both network and DB-wise. You will need a "serious" DB product. The only RDBMS I know that could handle that load is DB2 on a mainframe.
    Oracle - DB2 - MS Access -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts