My company is designing a database in which we intend to store data for several customers. We are trying to decide if,
A: we want to store all customer data in one set of tables with customer_id fields separating the data or,
B: storing each customers data in a separate schema.
I'd like to get some opinions on the pros and cons of these methods concerning maintainability, scalability, and performance.
I appreciate all the help.
Thanks,
Ted
|
||||
