pastebin - Benchmark PDO(mysql) vs mysqli()

Benchmark PDO(mysql) vs mysqli()

<?php
 
// Which query to test?
//$sql = "SELECT NULL";
$sql = "SHOW TABLE STATUS";
//$sql = "SELECT * FROM users";
 
// Your database credentials
$dbname = 'database';
$dbuser = 'username';
$dbpass = 'password';
 
// How many times to run the tests?
$runs = 10000;
 
// Wait how many seconds before ending the script?
set_time_limit(60);
 
// Don't render as HTML
header('Content-Type: text/plain');
 
function testMySQLi() {
        global $dbuser,$dbpass,$dbname,$sql;
        $start = microtime(1);
 
        $mdb = new mysqli('localhost',$dbuser,$dbpass,$dbname);
        $result = $mdb->query($sql);
        while ($row = $result->fetch_row())
        //while ($row = $result->fetch_array()) // fetch_row() is faster but not available in PDO
                continue;
 
        return microtime(1)-$start;
}
 
function testPDO() {
        global $dbuser,$dbpass,$dbname,$sql;
        $start = microtime(1);
                
        $pdb = new PDO('mysql:host=localhost;dbname='.$dbname,$dbuser,$dbpass);
        foreach ($pdb->query($sql) as $row)
                continue;
        
        return microtime(1)-$start;
}
 
$Ms = $Ps = array();
for ($c=-5;$c<=$runs;$c++) {
 
        $Ms[] = testMySQLi();
        $Ps[] = testPDO();
        
        // Ignore the first few runs
        if ($c==0) $Ps = $Ms = array();
}
 
echo "# of runs: $runs\n";
 
$Mt = array_sum($Ms);
echo "Total time for mysqli(): $Mt\n";
//print_r($Ms);
 
$Pt = array_sum($Ps);
echo "Total time for PDO(): $Pt\n";
//print_r($Ps);
 
$diff = abs($Pt-$Mt);
if ($Mt<$Pt) echo "mysqli was faster by $diff seconds.\n";
else if ($Pt<$Mt) echo "PGO was faster by $diff seconds.\n";
else echo "The times were equal!\n";

advertising

Create a Paste

Please enter your new post below (or upload a file instead):

Name / Title:
Tags:
Content Type:
Expire in: