If there are many fields, you can split the table vertically and use a fid to correspond. If there is a lot of data, you can consider splitting the table horizontally. There are many ways to split the table, so you can consider it again
If it can improve performance, it will be simpler to use read-write separation, and the effect will be obvious
Consider table splitting based on separation of reading and writing, for example, splitting tables by year based on upload time, splitting tables by user ID segment, or splitting tables based on your specific business
If there are many fields, you can split the table vertically and use a fid to correspond.
If there is a lot of data, you can consider splitting the table horizontally. There are many ways to split the table, so you can consider it again
If it can improve performance, it will be simpler to use read-write separation, and the effect will be obvious
Consider table splitting based on separation of reading and writing, for example, splitting tables by year based on upload time, splitting tables by user ID segment, or splitting tables based on your specific business
https://segmentfault.com/q/1010000000265631