require_once 'limb/core/common.inc.php'; require_once 'limb/dbal/common.inc.php'; echo "dbal common includes: " . (microtime(true) - $mark) . "\n"; $conn_string = "host=sheep port=5432 dbname=test user=lamb password=bar"; $pgsql_db = pg_connect('host=localhost user=php password=1561611 dbname=medkrug'); pg_query($pgsql_db, 'CREATE TABLE foo (bar varchar(10))'); pg_query($pgsql_db, 'INSERT INTO foo VALUES (\'some value\')'); $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $q = pg_query($pgsql_db, 'SELECT bar FROM foo'); while ($entry = pg_fetch_assoc($q)) { $bar = $entry['bar']; } } echo "native pgsql fetching: " . (microtime(true) - $mark) . "\n"; $conn = lmbDBAL::newConnection('pgsql://*****:*****@localhost/medkrug'); $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn); foreach ($rs as $record) { $bar = $record['bar']; } $rs->freeQuery(); } echo "lmbDBAL :: fetch(), array access: " . (microtime(true) - $mark) . "\n"; $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn); foreach ($rs as $record) { $bar = $record->get('bar'); }
sqlite_query($native_db, "INSERT INTO foo VALUES (null, 'some value{$i}')"); } } else { throw new Exception("Could not open sqlite db '{$db}'"); } if (++$counter == $test || $test == null) { $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $query = sqlite_query($native_db, 'SELECT bar FROM foo'); while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) { $bar = $entry['bar']; } } echo "{$counter}) native sqlite fetching: " . (microtime(true) - $mark) . "\n"; } $conn = lmbDBAL::newConnection('sqlite://localhost/' . $db); if (++$counter == $test || $test == null) { $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn); foreach ($rs as $record) { $bar = $record->get('bar'); } } echo "{$counter}) lmbDBAL :: fetch(), getter: " . (microtime(true) - $mark) . "\n"; } if (++$counter == $test || $test == null) { $mark = microtime(true); $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn); for ($i = 0; $i < 1000; $i++) { foreach ($rs as $record) {
require_once 'limb/core/common.inc.php'; require_once 'limb/dbal/common.inc.php'; echo "dbal common includes: " . (microtime(true) - $mark) . "\n"; $linter_db = linter_open_connect('SYSTEM', 'MANAGER', 'Demo', TM_AUTOCOMMIT); $cur = linter_open_cursor($linter_db); linter_exec_direct($cur, 'CREATE OR REPLACE TABLE "foo" ("bar" varchar(10));'); linter_exec_direct($cur, 'INSERT INTO "foo" VALUES (\'some value\');'); $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { linter_exec_direct($cur, 'SELECT "bar" FROM "foo";'); while (is_array($entry = linter_fetch_array($cur))) { $bar = $entry['bar']; } } echo "native linter fetching: " . (microtime(true) - $mark) . "\n"; $conn = lmbDBAL::newConnection('linter://*****:*****@localhost/Demo'); $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT "bar" FROM "foo";', $conn); foreach ($rs as $record) { $bar = $record['bar']; } $rs->freeQuery(); } echo "lmbDBAL :: fetch(), array access: " . (microtime(true) - $mark) . "\n"; $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT "bar" FROM "foo";', $conn); foreach ($rs as $record) { $bar = $record->get('bar'); }
function testNewConnection() { $conn = lmbDBAL::newConnection($this->dsn); $this->assertIsA($conn, 'lmbDbConnection'); }
require_once 'limb/core/common.inc.php'; require_once 'limb/dbal/common.inc.php'; echo "dbal common includes: " . (microtime(true) - $mark) . "\n"; $mysql_db = mysql_connect('localhost', 'gfu', '1561611'); mysql_select_db('gfu'); mysql_query('CREATE TABLE foo (bar varchar(10))'); mysql_query('INSERT INTO foo VALUES (\'some value\')'); $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $q = mysql_query('SELECT bar FROM foo'); while ($entry = mysql_fetch_assoc($q)) { $bar = $entry['bar']; } } echo "native mysql fetching: " . (microtime(true) - $mark) . "\n"; $conn = lmbDBAL::newConnection('mysql://*****:*****@localhost/gfu'); $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn); foreach ($rs as $record) { $bar = $record['bar']; } //$rs->freeQuery(); } echo "lmbDBAL :: fetch(), array access: " . (microtime(true) - $mark) . "\n"; $mark = microtime(true); for ($i = 0; $i < 1000; $i++) { $rs = lmbDBAL::fetch('SELECT bar FROM foo', $conn); foreach ($rs as $record) { $bar = $record->get('bar'); }