CODEWITHSUNDEEP
mysqlhistorical-db
user878559
user878559

Reputation: 21

How to store historical data i

I have a Mysql database with a large product table (ca. 700k rows and 35 columns) where every record (except for the PK variable) can be updated biweekly. Currently I included it in my database with the latest update. I want to store historical data for each update (e.g. from 1st of April 2021, 15th of April 2021, 1st of May 2021 ...). Is there a clever way to store such historical data in a run time friendly way without saving the 700k records of each biweekly update in a separate table?

Thanks!

Upvotes: 0

Views: 336

Answers (0)

Related Questions