undefinedfix
Sign in

The price table has 20 million pieces of data. It took more than three minutes to delete it

eutay edited in Wed, 10 Aug 2022

drop table price;Query OK, 0 rows affected (3 min 32.06 sec)

The price table has 20 million pieces of data. It took more than three minutes to delete it. Is it normal?

3 Replies
Matt
commented on Wed, 10 Aug 2022

For this quantity level, it is recommended to use the error storage process. Through do - Will loop, delete 1000 items each time, write some logic code, and output the progress of task operation.

talatccan
commented on Wed, 10 Aug 2022

Show profile

qcldg
commented on Wed, 10 Aug 2022

You can use hard links to delete large tables

lock This question has been locked and the reply function has been disabled.