• notice
  • Congratulations on the launch of the Sought Tech site

MySQL10W level mysql data insertion

At first, I didn't expect that the 10w data would be inserted for half an hour and only 2w.Later, an improved SQL batch insert
code is as follows:

--
insert before optimizing the code into table(mobile) values (138000000);
insert into table(mobile) values (138000000);
insert into table(mobile) values (138000000);
……

--After optimization, insert into table(mobile) values (138000000), (138000000), (138000000);……

--Insert 12w data after optimization, including php for data processing, and the cost is only 6s about.

Tags

Technical otaku

Sought technology together

Related Topic

0 Comments

Leave a Reply

+