Hello, I need suggestions for database architecture. I am going to build SaaS application for Company's employee management. Each company can create own account and they can have their employee management modules. So, Can I have to go with single Database OR Can I have one master database with individual database of each company.
Which Is technically best approach?
System have 1000+ companies and each company have 100+ employees. I can go with single DB with proper indexing but I am not sure about performance. So, Can anyone guide me to which database I have to prefer.
From what you described, it sounds like you'll want a single master database. The performance will not suffer from having 1000 companies x 100 employees on there. But, if you had 1000 different databases to manage, THAT would be a major headache!
Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me
Sign in to participate in this thread!