Database for multiple users

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Mr Tech
Forum Contributor
Posts: 424
Joined: Tue Aug 10, 2004 3:08 am

Database for multiple users

Post by Mr Tech »

If I create a script that allows multiple people to sign up for accounts, is it ok if they use the same database?

http://www.campaignmonitor.com is an email mailout software that allows you to signup and create newsletters, add subscribers etc. That must mean they would have millions of records in their database from all their accounts.

Would a site like campaign monitor use just one database to store all their information or would they need multiple databases? What is the best way to approach this?
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Database for multiple users

Post by jaoudestudios »

Just use 1 database. Having millions of records is fine. Normalise the database so there is no duplicate data.
Post Reply