confusion between pdo and mysqli

Question

I read many threads in stackoverflow and also googled but i still have one confusion

Please Tell me which will be better for me if i will have following

Database : MYSQL

10 000 Records in about 10 tables
100 tables
100 requests per second

i want to make website in which above details can be occur in future

if there are 100 users are viewing my site concurrently which will be best PDO or mysqli

I would think there will hardly be any difference. *Maybe* mysqli will be slightly faster. Why don't you benchmark it? — deceze, Jun 21 '12 at 10:38
you should be more worried about your table storage engine rather than how you are accessing the DB. http://stackoverflow.com/questions/20148/myisam-versus-innodb — Paul Bain, Jun 21 '12 at 10:39
as in it doesn't really matter in terms of performance. your bottleneck will likely not be the adapter, it'll be how you configure your database. — Paul Bain, Jun 21 '12 at 10:51

score 5 · Accepted Answer · answered Jun 21 '12 at 10:50

The Choosing an API chapter in the PHP manual says this:

The overall performance of all three extensions is considered to be about the same. Although the performance of the extension contributes only a fraction of the total run time of a PHP web request. Often, the impact is as low as 0.1%.

To sum up: if performance is your only concern, it's irrelevant which one you choose. (Not to mention that database size or complexity is basically MySQL Server's problem.)

score 1 · Answer 2 · answered Jun 21 '12 at 11:08

In my opinion PDO is better than mysqli and there are no doubts. There are support for another databases, named parameters, easier SQL-Injection security (using prepared statements).

Mysqli is slightly faster, but i think it cannot be main reason in this case.

confusion between pdo and mysqli

2 Answers2