- Joined
- Aug 6, 2005
- Messages
- 8,195
- Likes received
- 598
- Thanks received
- 188
- Location
- Troll farm somewhere in Russia
Say I have a DB set which holds results and other info about my customers.
This info changes over time and I want to take regular snapshots and compare the changes. An example would be:
Customer_a signs up and I take a snapshot of certain things about their website. This goes into a table
Then each week I want to take the same snapshot but the data will have changed. I'd like to keep each snapshot and be able to do comparisons and generate reports.
Do I need a new table for each weekly snapshot or is there a cleverer/more efficient way to just have the snapshot data in 1 table and archive the historical ones?
I'll be using PHP as the reporting interface.
This info changes over time and I want to take regular snapshots and compare the changes. An example would be:
Customer_a signs up and I take a snapshot of certain things about their website. This goes into a table
Then each week I want to take the same snapshot but the data will have changed. I'd like to keep each snapshot and be able to do comparisons and generate reports.
Do I need a new table for each weekly snapshot or is there a cleverer/more efficient way to just have the snapshot data in 1 table and archive the historical ones?
I'll be using PHP as the reporting interface.
)