Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
benchmark.php	2.11 KB	-rwxr-xr-x
client.php	4.06 KB	-rwxr-xr-x
pdo.php	1.69 KB	-rwxr-xr-x
test-active-record.php	4.6 KB	-rwxr-xr-x
test-active-recs2.php	1.41 KB	-rwxr-xr-x
test-active-relations.php	2.97 KB	-rwxr-xr-x
test-active-relationsx.php	24.45 KB	-rwxr-xr-x
test-datadict.php	7.53 KB	-rwxr-xr-x
test-perf.php	897 B	-rwxr-xr-x
test-pgblob.php	1.99 KB	-rwxr-xr-x
test-php5.php	2.57 KB	-rwxr-xr-x
test-xmlschema.php	1.27 KB	-rwxr-xr-x
test.php	54.96 KB	-rwxr-xr-x
test2.php	566 B	-rwxr-xr-x
test3.php	993 B	-rwxr-xr-x
test4.php	4.64 KB	-rwxr-xr-x
test5.php	1.43 KB	-rwxr-xr-x
test_rs_array.php	677 B	-rwxr-xr-x
testcache.php	887 B	-rwxr-xr-x
testdatabases.inc.php	18.59 KB	-rwxr-xr-x
testgenid.php	723 B	-rwxr-xr-x
testmssql.php	2.06 KB	-rwxr-xr-x
testoci8.php	2.39 KB	-rwxr-xr-x
testoci8cursor.php	2.96 KB	-rwxr-xr-x
testpaging.php	2.33 KB	-rwxr-xr-x
testpear.php	954 B	-rwxr-xr-x
testsessions.php	2.54 KB	-rwxr-xr-x
time.php	513 B	-rwxr-xr-x
tmssql.php	1.83 KB	-rwxr-xr-x
xmlschema-mssql.xml	832 B	-rwxr-xr-x
xmlschema.xml	961 B	-rwxr-xr-x

Code Editor : benchmark.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	<title>ADODB Benchmarks</title>
</head>

<body>
<?php
/*
@version   v5.20.18  28-Jun-2020
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
@copyright (c) 2014      Damien Regad, Mark Newnham and the ADOdb community
  Released under both BSD license and Lesser GPL library license.
  Whenever there is any discrepancy between the two licenses,
  the BSD license will take precedence.

Benchmark code to test the speed to the ADODB library with different databases.
  This is a simplistic benchmark to be used as the basis for further testing.
  It should not be used as proof of the superiority of one database over the other.
*/

$testmssql = true;
//$testvfp = true;
$testoracle = true;
$testado = true;
$testibase = true;
$testaccess = true;
$testmysql = true;
$testsqlite = true;;

set_time_limit(240); // increase timeout

include("../tohtml.inc.php");
include("../adodb.inc.php");

function testdb(&$db,$createtab="create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)")
{
GLOBAL $ADODB_version,$ADODB_FETCH_MODE;

adodb_backtrace();

$max = 100;
	$sql = 'select * from ADOXYZ';
	$ADODB_FETCH_MODE = ADODB_FETCH_NUM;

//print "<h3>ADODB Version: $ADODB_version Host: <i>$db->host</i> &nbsp; Database: <i>$db->database</i></h3>";

// perform query once to cache results so we are only testing throughput
	$rs = $db->Execute($sql);
	if (!$rs){
		print "Error in recordset<p>";
		return;
	}
	$arr = $rs->GetArray();
	//$db->debug = true;
	global $ADODB_COUNTRECS;
	$ADODB_COUNTRECS = false;
	$start = microtime();
	for ($i=0; $i < $max; $i++) {
		$rs = $db->Execute($sql);
		$arr = $rs->GetArray();
	   //		 print $arr[0][1];
	}
	$end =  microtime();
	$start = explode(' ',$start);
	$end = explode(' ',$end);

//print_r($start);
	//print_r($end);

//  print_r($arr);
	$total = $end[0]+trim($end[1]) - $start[0]-trim($start[1]);
	printf ("<p>seconds = %8.2f for %d iterations each with %d records</p>",$total,$max, sizeof($arr));
	flush();

//$db->Close();
}
include("testdatabases.inc.php");

</body>
</html>

${this.title}

Code Editor : benchmark.php