News Feed
Jobs Feed
Sections

Recent Jobs

News Archive
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




Similar Posts

Blond R's Blog: Set up IIS 7 w/ MySQL and PHP 5

DevShed: Creating a Login Script for a PHP/MySQL Blogging System (Part 1)

The Bakery: Five New Articles/Tutorials/Components Posted

Edin Kadribasic's Blog: PHP 4.4.6-win32 with MySQL 5.0.36

Greg Bulmash's Blog: Creating A Simple Rating Script With PHP And MySQL


Community Events







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


job ajax book releases package application example PHP5 security cakephp release framework zendframework database developer PEAR conference code zend mysql

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