Mysql Insert Declaration Optimization

1) Assume that you are inserting very many rows from the same customer at the same time, using the INSERT statement for multiple value tables.

This is faster than using separate INSERT statements (several times in some cases).
Insert into test values (1,3), (1,4) ...

2) Suppose you insert very many rows from different customers. Can get higher speed by using the Insert delayed statement.

The implication of delayed is that the INSERT statement runs immediately, in fact the data is placed in the queue of memory and is not actually written to disk. This is much faster than inserting each statement, and low_priority the opposite, inserting the table after all other users have read and write it.

3) Place index files and data files on separate disks (using the options in the Build table).

4) Assume a bulk insert. The ability to add the value of the bulk_insert_buffer_size variable to raise the speed, but. This can only be used on MyISAM tables.

5) When loading a table from a text file, use load DATA INFILE. This is usually 20 times times faster than using very many INSERT statements.

6) Use the Replace statement instead of INSERT, depending on the application.

7) Ignore duplicate records according to different application cases Ignorekeyword.

Mysql Insert Declaration Optimization