Do I need a separate database for each B2B customer?

Just what it says on the tin… is it safe & scalable to store data from different customers in the same database?

For example, if each customer has 1000s of invoices saved in my database, then each time my app looks for/shows invoices for ANY of my customers, it will need to look through ALL the invoices for ALL my customers… that doesn’t seem to be the best way, but is that how others do it?

Hi there, @TM-123… the short answer is yes, you can/should store data for different customers in the same data types, and you should use privacy rules to restrict data to its associated customer.

Best…
Mike

1 Like