public function testTimeIt()
{
$res = timeit('usleep(200000)', NULL, 10);
$this->assertEquals(10, $res[0]);
$this->assertEquals(0.2, $res[1], '', 0.001);
$this->assertRegExp('/^200\\.\\d\\dms$/', $res[2]);
}
});
echo "\nSINGLE STRING PARAM\n";
timeit("single scalar ", function () {
$_SERVER['db']->fetchOne("SELECT * FROM tblServer WHERE vchHostname = ?", 'test');
});
timeit("shorthand array ", function () {
$_SERVER['db']->fetchOne("SELECT * FROM tblServer WHERE vchHostname = ?", array('test'));
});
timeit("shorthand named array ", function () {
$_SERVER['db']->fetchOne("SELECT * FROM tblServer WHERE vchHostname = ?host", array('host' => 'test'));
});
timeit("prepare()->bindString()->fetchOne() ", function () {
$_SERVER['db']->prepare("SELECT * FROM tblServer WHERE vchHostname = ?host")->bindString('host', 'test')->fetchOne();
});
timeit("prepare()->bindString()->fetchAll() ", function () {
$_SERVER['db']->prepare("SELECT * FROM tblServer WHERE vchHostname = ?host")->bindString('host', 'test')->fetchAll();
});
/**
* Time a callback function.
*
* Execute callback 'n' times in 'm' loops and calculate the average
*
* @param string $str_name
* @param $callback
* @param int $int_times
* @param int $int_loops
* @return array
*/
function timeit($str_name, $callback, $int_times = 3, $int_loops = 2000)
{
echo str_pad($str_name, 50);
