un-optimized version:<\/p>\n
\r\n\r\n$wpdb;\r\n\r\n$t1 = microtime(TRUE);\r\n\r\n\r\nfor($i = 0; $i < 10000; $i++){ $wpdb->query(\"\r\n\t\tINSERT INTO test (value) VALUES ('xxx')\r\n\t\");\r\n}\r\n\r\n\r\n$t2 = microtime(TRUE);\r\n\r\necho $t2 - $t1;\r\n\r\ndie;\r\n\r\n<\/pre>\nRuntime(Seconds):
\n4.44
\n4.61
\n4.33<\/p>\n
Optimized version:<\/p>\n
\r\n\r\n$wpdb;\r\n\r\n$t1 = microtime(TRUE);\r\n\r\n$sql = \"INSERT INTO test (value) VALUES \";\r\n$arr = array();\r\n\r\nfor($i = 0; $i < 10000; $i++){ \r\n\t$arr[] = \"('xxx')\"; \r\n}\r\n \r\n$sql .= implode(',', $arr); \r\n$wpdb->query( $sql );\r\n\r\n$t2 = microtime(TRUE);\r\n\r\necho $t2 - $t1;\r\n\r\ndie;\r\n\r\n<\/pre>\nRuntime(Seconds):
\n0.074
\n0.091
\n0.065<\/p>\n
Use of transaction and commit:<\/p>\n
\r\n\r\n$wpdb;\r\n\r\n$t1 = microtime(TRUE);\r\n\r\n$wpdb->query('START TRANSACTION');\r\n\r\nfor($i = 0; $i < 10000; $i++){\r\n\t$wpdb->query(\"\r\n\t\tINSERT INTO test (value) VALUES ('xxx')\r\n\t\");\r\n}\r\n\r\n$wpdb->query('COMMIT');\r\n\r\n$t2 = microtime(TRUE);\r\n\r\necho $t2 - $t1;\r\n\r\ndie;\r\n\r\n<\/pre>\nRuntime(Seconds):
\n2.21
\n2.55
\n2.47<\/p>\n","protected":false},"excerpt":{"rendered":"