How fast is PDO?

Question

PHP

Started a new project and finally decided to move from mysql_ to PDO. After a day of working with him, I got the impression that he was very slow, I tested on simple queries like:

$selectUser = $pdo->query('SELECT * FROM admin');
$selectUser = $selectUser->fetch();

It seems to me or is it really slower?
UPD: For those who wanted to see numbers:
PDO - 0.00030599999999996
mysql_: 0.00011000000000006

Answer 1

Here is a good article for beginners, read the comments, there are a lot of reviews and use cases people brought, the main idea is that pdo is initially object-oriented and has prepared statements. It is a) convenient b) safe. All other pipiskomeryalki in projects like "my second improved blog in php" do not make sense. For the gain in speed of development/security is more important today than microadvantages from change of the driver to a DB.

Answer 2

Of course, it is slower, this comes from the very principle of its work. But who is stopping you from implementing caching?

Answer 3

You can start with the fact that mysql_the functions have been removed from php, as far as I understand, since version 5.5, and only mysqli_analogues that are not faster than PDO remain. And the rest I think you have already learned from other answers.

Answer 4

Open the console, there may be an error there. You can also see Network, in the same developer panel.