[for] mysql the same table query speed difference is too big-CodePudding

Home > database > [for] mysql the same table query speed difference is too big

[for] mysql the same table query speed difference is too big

Time：02-26

Consult a great god!!!!!!
There is A table in A DB, save the data in 30 days, insert new data every day & amp; Delete old data,
Data query for 10 days, need to 35 seconds,
The whole table to generate a new table, the new table query 2 seconds,

In the DB B, have the same update tables, query time in 1 seconds,

Two in the DB table structure, data insertion way,

Ask how to troubleshoot the cause of query speed difference so big,

Page link：https//www.codepudding.com/database/102665.html

Prev:The mysql database, access to the table, downward flow is far less than the data of table size

Next:For help, the date format how to compare the query 15/10/2020 10:22:19. 062

Tags：

MySQL

Links：
CodePudding