Hi,
I'm working on a web 2.0 project that targeting small to medium size companies
for providing business services. Companies simply register to the site and then
start their business by loading their data, sharing and discussing them with
others.
The design/architectural decision now we are facing from database perspective
is how we should store companies' specific data? One way is to put all of them
in a single database and partition them by company-id and the other one is to
create, on the fly, a new database per company . The justification for the
latter is that MySQL is not powerful enough (compare to Oracle or DB2) to
handle large amount of data and concurrent users.
I'm new to MySQL and don't know that much about it and this is why I'd like to
discuss this concern here.
Thanks,
Mohammad
Ask a question on any topic and get answers from real people. Go to
Yahoo! Answers and share what you know at http://ca.answers.yahoo.com
