| |

VerySource

 Forgot password?
 Register
Search
View: 39|Reply: 3

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

[Copy link]

1

Threads

2

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-1-6 06:20:01
| Show all posts |Read mode
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
Reply

Use magic Report

1

Threads

2

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

 Author| Post time: 2020-1-6 09:06:01
| Show all posts
Why is it slow? Which master clicks on the idea
Reply

Use magic Report

0

Threads

2

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-1-6 12:21:01
| Show all posts
How can it be very slow to insert only 5 in accordance with common sense?

Whether to use import or load
Reply

Use magic Report

0

Threads

2

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-7-23 15:15:01
| Show all posts
When char and varchar fields grow, the table can be directly modified without rebuilding

Import and export with commands, it will not be slow
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list