The drop table is rebuilt and the previous data is loaded. As a result, the current insert of one or two data is normal,

pjlzml

Drop table reconstruction, two of the fields, one changed from char8 to char20, one char30 to char100, the field name is unchanged, the previous data is loaded, and the current insert one or two data is normal, and more than five are extremely slow, the original table There are more than 9M records

pjlzml

Why is it slow? Which master clicks on the idea

伊洛切尔

How can it be very slow to insert only 5 in accordance with common sense?

Whether to use import or load

vincentpan

When char and varchar fields grow, the table can be directly modified without rebuilding

Import and export with commands, it will not be slow