1. Data as small as possible, reasonable design field type
2, use indexes
Indexes are like books, which can quickly locate the location you are looking for. However, it will take up disk space, affecting updates, insert, etc., when used reasonably.
3, try to use NOT NULL, set the default value, less NULL
4, regular maintenance