Menu
I'm using PDO in my PHP application. It connects to a MySQL server on the same server:
$db = new PDO(mysql:host=localhost;dbname=test, $username, $password); I created two pages with the same output (just some dummy data in plain html) one of which contains the call to create PDO. If I open the page that uses no connection the response is between 0.5 and 1 second quicker.
271
Here you can see that PDO is only 1% faster than mysqli.
Performance. While both PDO and MySQLi are quite fast, MySQLi performs insignificantly faster in benchmarks - ~2.5% for non-prepared statements, and ~6.5% for prepared ones. Still, the native MySQL extension is even faster than both of these.
The PDO represents a connection between PHP and a database server. The PDOStatement represents a prepared statement and, after the statement is executed, an associated result set. The PDOException represents an error raised by PDO.
I've been doing some googling, and after reading this thread, I changed localhost to 127.0.0.1. That solves the problem....
139
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
