Simple test of performance impact when PHP inserts a record into mysql and does not output each result _ MySQL

Simple test: performance impact when PHP inserts a record into mysql and when each result is not output. here we use 100 records and records to insert an experiment to see whether there is an output or no output impact when inserting.

Table structure

Field	Type	Null	Default	Note
Id	Int (11)	No
Name	Char (50)	No
Pwd	Varchar (255)	No
Ptime	Bigint (20)	No
State	Int (11)	No

Insert 10000 entries

Output time consumption: 256 S concurrency: 39/S

No output time consumption: 230 S concurrency: 43/S

Insert 100 entries

Output time consumption: 1.656 S concurrency: 60.386/S

No output Time: 1.547 S concurrency: 64.641/S

A simple test shows that it is not necessary to output the result information when executing SQL statements in batches. check the results after all SQL statements are executed.