Which is fastest in PHP- MySQL or MySQLi?

by

The MySQL extension is very slightly faster than MySQLi in most benchmarks I’ve seen reported. The difference is so slight, however, that this should probably not be your criterion for deciding between the two.

Other factors dwarf the difference in performance between mysql and mysqli. Using mod_php or FastCGI, a bytecode cache like APC, or using data caching judiciously to reduce database hits, are far more beneficial for overall performance of PHP scripts than the choice of MySQL extension.

Don’t be penny wise and pound foolish! 🙂

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. inserting information and image in php and mysql
  3. Can I mix MySQL APIs in PHP?
  4. mysqli or die, does it have to die?
  5. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  6. How to change mysql to mysqli?
  7. MySQL vs MySQLi when using PHP [closed]
  8. How to get count of rows in MySQL table using PHP?
  9. MySQLi prepared statements error reporting [duplicate]
  10. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  11. Why is mysqli giving a “Commands out of sync” error?
  12. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  13. How can I enable the MySQLi extension in PHP 7?
  14. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  15. Advantages Of MySQLi over MySQL [closed]
  16. check if the query results empty row mysqli [duplicate]
  17. PHP PDO and MySQLi [duplicate]
  18. Is mysql_real_escape_string() necessary when using prepared statements?
  19. Updating from MYSQL to MYSQLI [duplicate]
  20. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  21. How to prepare statement for update query? [duplicate]
  22. php password_verify() hash and pass won’t match
  23. How to use mysqli_query() in PHP?
  24. PHP to MySQL SSL Connections
  25. Strange problem with the length of the field gotten from database [duplicate]
  26. PHP: mysql v mysqli v pdo [closed]
  27. How do I ensure I caught all errors from MySQLi::multi_query?
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. Why cannot the PHP hide the error message thrown by the MySQL connection?

Leave a Comment