Dead-Knock MySQL (2)

Want to test their own query statements, import batches of data, at first very slow to think it is their own statement has a problem, then it is this autocommit, the efficiency of a lot of difference ...

Delimiter//CREATE PROCEDURE new (in NUM int) begin declare I int;  Set i=0; While I<num do

INSERT into new values (I, "name");  Set i=i+1;  End while; End//delimiter;

No index, test

Mysql> SELECT * FROM new where name= ' haha '; +-----------+------+ | ID | name | +-----------+------+ | 100000000 | haha | +-----------+------+ 1 row in Set (0.13 sec)

Mysql> SELECT * from new where id=100000000; +-----------+------+ | ID | name | +-----------+------+ | 100000000 | haha | +-----------+------+ 1 row in Set (0.00 sec)

Mysql> SELECT * FROM new where name= ' haha '; +-----------+------+ | ID | name | +-----------+------+ | 100000000 | haha | +-----------+------+ 1 row in Set (0.09 sec)

The same data query shaping and character difference is very big AH

Remember to look for more plastic surgery later .....

Dead-Knock MySQL (2)