PHPize Online / SQLize Online  /  SQLtest Online

<?php $names = array_fill(0, 50000, array('foo', 'ln', 'ad', 'tel', 'sz', 'wgh')); $start = microtime(true); $insert = 'INSERT INTO `foo` (firstname, lastname, address, tel, size, weight) VALUES '; foreach ($names as $name) $insert .= '(\''.implode('\', \'', $name).'\'),'; $pdo->query(trim($insert, ',')); $duration = microtime(true) - $start; echo 'Duration: '.$duration; echo PHP_EOL; $start = microtime(true); $insert = 'INSERT INTO `foo` (firstname, lastname, address, tel, size, weight) VALUES '; foreach($names as $name) $insert.= '(?,?,?,?,?,?),'; $names = array_merge(...$names); $stmt = $pdo->prepare(trim($insert, ',')); $stmt->execute($names); $duration = microtime(true) - $start; echo 'Duration: '.$duration;