Hi everyone. We are modeling our data based on one table per customer, so it's easy to drop one or add one without having to put offline while altering the table.
I have to questions regarding this model: a) Our customers data size is very uneven. Some have millions of rows, some just a few thousands. This model of one table per customer will give good load balancing? b) Won't it be too heavy on resources to have thousands of htables opened? Thanks all for your time!
