MySql query optimization Summary (1)

MySql query optimization Summary (1) 1. Big Data paging query, varchar and other large fields to load the Common Code: SELECTaj. N_BH, aj. C_AM, aj. C_AHFROMt_ajASajORDERBYaj.D_LARQDESCLIMIT100, 10? 10 million pieces of data, query time? 0.73 s? After optimization: selectaj. C_AM, aj. C_AH, aj. N_BHFRO

MySql query optimization Summary (1) 1. Big Data paging query, varchar, and other large fields are lazy loaded. Common Code: SELECT aj. n_BH, aj. c_AM, aj. c_AHFROM t_aj AS ajORDER BY aj. d_LARQ DESCLIMIT 100,10? 10 million data records, query time? 0.73 s? After optimization: select aj. C_AM, aj. C_AH, aj. N_BHFRO

MySql query optimization Summary (1)

1. Big Data paging query, varchar, and other large fields are lazily loaded

Common Code:

SELECT aj. N_BH, aj. C_AM, aj. C_AHFROM t_aj AS ajORDER BY aj. D_LARQ DESCLIMIT 100,10

? 10 million data records, query time? 0.73 s

?

After optimization:

Select aj. c_AM, aj. c_AH, aj. n_BHFROM (SELECT aj. n_BH, aj. d_LARQFROM t_aj AS ajORDER BY aj. d_LARQ DESCLIMIT 100,10) T inner join t_aj aj on t. n_BH = aj. n_BH

? 10 million data records, query time? 0.17 s

?