MySql has a complex structure is list data volume increases quickly (real-time positioning information), a month to tens of millions, but the repository for the rest of the table data volume is not large, is this time the rolls table better or other way, because this table query operation is not much,

CodePudding user response:

Make a history table, save the data in the table in the history table on a regular basis

CodePudding user response:

The current table to keep only the data of one day, the other in the history table,
History table for too long (more than one year) data transfer to other libraries,

CodePudding user response:

The combined with the actual query case,