News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

John Walsh's Blog:
Benchmark - MYSQL vs MYSQLi
June 12, 2007 @ 13:34:00

John Walsh got to thinking about performance when it comes to the MySQL functions versus MySQLi in PHP - this quick post is the result:

I've decided that a little investigation in weather it can connect,query and close faster than the MYSQL function I prefer the MYSQLi version as the _connect function is a lot more organised with the DB select in it.

The code used for the benchmarks is simple - just a connect, query and close (no fetch). The results of running each 1500 times shows that, by a pretty narrow margin, the MySQL extension comes in around 92 milliseconds faster than MySQLi.

1 comment voice your opinion now!
mysql benchmark mysqli query connect close mysql benchmark mysqli query connect close


blog comments powered by Disqus

Similar Posts

PHPImpact Blog: Zend Framework Controller: 22% Drop in Responsiveness

Ulf Wendel: Not only SQL injection: I donít trust you!

DevShed: Using Directory Iterators and MySQL with Adapter Objects with PHP

Vexxhost.com: Top 5 new (and cool!) features in PHP5 that you probably haven't heard of

WebReference.com: Accessing Your MySQL Database from the Web with PHP


Community Events

Don't see your event here?
Let us know!


symfony2 application php7 example api part2 conference configure voicesoftheelephpant podcast release introduction opinion framework series interview community laravel performance library

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework