public function run()
{
$this->prepareTables();
$repeats = $this->getRepeats();
$sql = 'SELECT txt FROM test';
$bar = new CliProgressBar($repeats);
for ($i = 1; $i <= $repeats; ++$i) {
Timer::start();
$result = ODb::rows($sql);
foreach ($result as $value) {
}
Timer::stop();
$bar->update($i);
}
$this->addResult('non-generator', Timer::get());
Timer::reset();
$bar = new CliProgressBar($repeats);
// Db class initialization
$pool = new ConnectionPool();
$conn = new PdoConnection('master');
$conn->setDsn("mysql:host=localhost;dbname={$this->database};charset=utf8")->setUserName('root')->setPassword('')->setOptions([PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => false]);
$pool->addConnection($conn, true);
PdoAdapter::setPool($pool);
Db::setAdapter(PdoAdapter::instance());
for ($i = 1; $i <= $repeats; ++$i) {
Timer::start();
$result = Db::rows($sql);
foreach ($result as $value) {
}
Timer::stop();
$bar->update($i);
}
$this->addResult('generator', Timer::get());
$this->cleanup();
}
/**
* Get default connection resource
*
* return \PDO
*/
public function getConnection()
{
if (null === static::$connection) {
$conn = static::$pool->getConnection(static::$connection_name);
static::$connection = null === $conn->getResource() ? $conn->create() : $conn->getResource();
}
return static::$connection;
}