Table Structure Design (breaking a large table into multiple small tables)

If the data in a table is very large and the data in the table has multiple statuses, the query will be very slow.

What should we do?

First, you need a summary table, which stores the IDs of all data. Other data is saved into N tables according to N states.

In this way, you only need to query a certain type of data in the corresponding table. In this case, the query results will be very fast.

However, this approach will also lead to a drawback when you need to query all the data, because the multi-Table relationship is required, it will be very slow.

This method is not suitable when you need to query all the data frequently. However, this method is correct when only the category is queried.