A database record pixels after long-term use, points accumulated a lot of time table
Such XS20200920_08_09 table, which means one day data from 8 to 9 PM, every day there are 24 tables, each table data rows have hundreds of thousands of to one million lines,
Ten days will be delete the tables, 10 days will be 240 such table, now I wrote
Truncate Table XS20200920_08_09
Drop Table XS20200920_08_09
.
.
.

I clear the table first, and then delete table, but the speed is slow, is there a faster writing the great god?

CodePudding user response:

You are going to drop table will truncate to do