We offer outstanding professional Joomla!TM extensions.

Professional Joomla! Extensions

Professional Joomla! Extensions

Blog Benchmarking MySQL vs MySQLi drivers with Joomla! database layer

Newsletter

Enter your email address:



Delivered by FeedBurner

Latest on Forum

Member Login



Forum Tags


Advanced search
Benchmarking MySQL vs MySQLi drivers with Joomla! database layer
Monday, 06 July 2009 03:47

Which Joomla! database driver to use: MySQLi or MySQL? What is faster and which Joomla! database layer methods are faster? Here is short but interesting benchmark!

We used Windows XP, PHP 5.2.6, MySQL 5.0.18, PHP as Apache handler.

Each method was tested 5 times, fastest speed and biggest memory usage were used for results.

Show/hide testing script


Results:

 

Method MySQL MySQLi
Time Memory Time Memory
$rows = $db->loadObjectList(); 0.426 254.36 kB 0.453 254.38 kB
$rows = $db->loadAssocList(); 0.359 254.16 kB 0.378 254.25 kB
$rows = $db->loadRowList(); 0.369 246.00 kB 0.369 246.20 kB
$row = $db->loadObject(); 0.062 8.77 kB 0.061 8.77 kB
$row = $db->loadAssoc(); 0.061 7.23 kB 0.058 7.23 kB
$row = $db->loadRow(); 0.060 6.48 kB 0.056 6.46 kB


Conclusion:

MySQLi is not faster than MySQL for list queries and has similar memory usage.

Fetching data into arrays is about 15-20% faster than into objects.

Most Joomla! queries are list queries (list queries also take more time), so we recommend to use MySQL driver.

 
 
Copyright © 2008-2012 Blogomunity.com
Trademarks and tradenames used herein are the property of their respective holders.
The Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries. Blogomunity is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.