PHP MySQLi Multiple Inserts

by

I went ahead and ran a test where one query uses a prepared statement, and the other builds the entire query then executes that. I’m probably not making what I’m wanting to know easy to understand.

Here’s my test code. I was thinking prepared statements sort of held back execution until a $stmt->close() was called to optimize it or something. That doesn’t appear to be the case though as the test that builds the query using real_escape_string is at least 10 times faster.

<?php

$db = new mysqli('localhost', 'user', 'pass', 'test');

$start = microtime(true);
$a="a";
$b = 'b';

$sql = $db->prepare('INSERT INTO multi (a,b) VALUES(?, ?)');
$sql->bind_param('ss', $a, $b);
for($i = 0; $i < 10000; $i++)
{
    $a = chr($i % 1);
    $b = chr($i % 2);
    $sql->execute();
}
$sql->close();

echo microtime(true) - $start;

$db->close();

?>

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. How to change mysql to mysqli?
  4. Best way to INSERT many values in mysqli?
  5. Call to a member function bind_param() on a non-object [duplicate]
  6. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  7. MySQLi prepared statements error reporting [duplicate]
  8. How can I get an unknown username given an ID?
  9. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  10. mysqli_query() expects parameter 1 to be mysqli, object given
  11. MySQLi query returns only one row
  12. MySQLi count(*) always returns 1
  13. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  14. Use one bind_param() with variable number of input vars
  15. Using Mysqli bind_param with date and time columns?
  16. PHP UPDATE prepared statement
  17. SELECT * FROM in MySQLi
  18. How to echo a MySQLi prepared statement?
  19. MySQLi prepared statements with IN operator [duplicate]
  20. Mysqli fetch_assoc vs fetch_array
  21. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  22. Is mysqli extension enabled in this php configuration?
  23. php warning: mysqli_close() expects parameter 1 to be mysqli
  24. Is mysqli_real_escape_string safe?
  25. Getting error mysqli::real_connect(): (HY000/2002): No such file or directory when I try to access my project on live server [duplicate]
  26. Get number of rows matched by UPDATE query with PHP mysqli
  27. How to use mysqli_query() in PHP?
  28. Strange problem with the length of the field gotten from database [duplicate]
  29. Mysqli multiple row insert, simple multi insert query [duplicate]
  30. Single Result From SUM With MySQLi

Leave a Comment