Speeding up inserts with INSERT DELAYED
If your insert statements are not time critical, you can use insert delayed in your SQL to speed things up. The syntax is as follows.
INSERT DELAYED table (col1, col2) VALUES ('a', 'b');
Insert delayed can be used with MyISAM and Memory, but cannot be used with InnoDB.
The advantage of using insert delayed is that the MySQL server returns a success message straight away so the script can keep going, without it actually having to do the insert. This allows the MySQL server to carry it out when it isn’t busy, and do several at the same time.
It’s appropriate for tables such as logs tables where it doesn’t matter too much if they don’t go in straight away.
If your insert statements are not time critical, you can use insert delayed in your SQL to speed things up. The syntax is as follows.
INSERT DELAYED table (col1, col2) VALUES ('a', 'b');
Insert delayed can be used with MyISAM and Memory, but cannot be used with InnoDB.
The advantage of using insert delayed is that the MySQL server returns a success message straight away so the script can keep going, without it actually having to do the insert. This allows the MySQL server to carry it out when it isn’t busy, and do several at the same time.
It’s appropriate for tables such as logs tables where it doesn’t matter too much if they don’t go in straight away.