The following description of the database SQL optimization method.

Use paginated query to avoid throughput of full data at one time, and can use 15 data network traffic

B-Tree index reduces the operation of the hard disk by 10 according to the query conditions to improve the query efficiency

Reduce large-scale transaction operations in the business, avoid processing too much data in one transaction, remove unnecessary queries, try to ensure that all read operations are necessary in transactions, and reduce the amount of locked data

Appropriately increase the cache capacity, increase the cache hit ratio, and reduce the load of the hard disk 10