Hi,

Our database is an analytics database and it is growing very rapidly. Currently we have around 5 tables which are increasing at a rate of 2 GB per day. The increase daily is for all clients combined. We are seeing a decrease of around .3 sec for every one week with the combined volume. We are planning to split these tables for each customer so that we can keep the storage and query time under control. Our current table is customer_log, customer_stat and we are thinking of splitting it into customer_log_12 , customer_stat_12 for customer with id 12 etc.., But our problem is how to associate the table dynamically during query time based on the customer id.

I have tried searching it in the forums and could not find anything.

Any help would be appreciated.

Thanks,
Aditya