HI,
We migrate from Foxpro(VFP9) to MySql.
I store data for multiple customers in multiple tables (DBF) with over 100 fields called history.
We reach the limit of foxpro. We accumulate 1,000,000 records per day per customer.
My question is:"what's the best way to store that amount of data using mySql?"
1 unique history table with a customer code field?
1 history table for each customer?
1 history table per year per customer?
any other idea ?
I have to provide interface online for each customer so they can query the history table at any time. They can go 10 years back to produce a report.
Any suggestion are welcome
Bob
We migrate from Foxpro(VFP9) to MySql.
I store data for multiple customers in multiple tables (DBF) with over 100 fields called history.
We reach the limit of foxpro. We accumulate 1,000,000 records per day per customer.
My question is:"what's the best way to store that amount of data using mySql?"
1 unique history table with a customer code field?
1 history table for each customer?
1 history table per year per customer?
any other idea ?
I have to provide interface online for each customer so they can query the history table at any time. They can go 10 years back to produce a report.
Any suggestion are welcome
Bob