MySQL, Query, Optimization, Web Performance, Database.
statements, streamlined statements 5, the integration of repeated execution of the statement 6, cache query results 5. Index optimization 5.1. Index advantages: 1, Maintain data integrity 2, improve data query performance 3, improve the connection operation of the table (join) 4, Sort the query