[903] | 1 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
---|
| 2 |
|
---|
| 3 | <html>
|
---|
| 4 | <head>
|
---|
| 5 | <title>ADODB Benchmarks</title>
|
---|
| 6 | </head>
|
---|
| 7 |
|
---|
| 8 | <body>
|
---|
| 9 | <?php
|
---|
| 10 | /*
|
---|
| 11 | V4.81 3 May 2006 (c) 2000-2007 John Lim (jlim#natsoft.com.my). All rights reserved.
|
---|
| 12 | Released under both BSD license and Lesser GPL library license.
|
---|
| 13 | Whenever there is any discrepancy between the two licenses,
|
---|
| 14 | the BSD license will take precedence.
|
---|
| 15 |
|
---|
| 16 | Benchmark code to test the speed to the ADODB library with different databases.
|
---|
| 17 | This is a simplistic benchmark to be used as the basis for further testing.
|
---|
| 18 | It should not be used as proof of the superiority of one database over the other.
|
---|
| 19 | */
|
---|
| 20 |
|
---|
| 21 | $testmssql = true;
|
---|
| 22 | //$testvfp = true;
|
---|
| 23 | $testoracle = true;
|
---|
| 24 | $testado = true;
|
---|
| 25 | $testibase = true;
|
---|
| 26 | $testaccess = true;
|
---|
| 27 | $testmysql = true;
|
---|
| 28 | $testsqlite = true;;
|
---|
| 29 |
|
---|
| 30 | set_time_limit(240); // increase timeout
|
---|
| 31 |
|
---|
| 32 | include("../tohtml.inc.php");
|
---|
| 33 | include("../adodb.inc.php");
|
---|
| 34 |
|
---|
| 35 | function testdb(&$db,$createtab="create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)")
|
---|
| 36 | {
|
---|
| 37 | GLOBAL $ADODB_version,$ADODB_FETCH_MODE;
|
---|
| 38 |
|
---|
| 39 | adodb_backtrace();
|
---|
| 40 |
|
---|
| 41 | $max = 100;
|
---|
| 42 | $sql = 'select * from ADOXYZ';
|
---|
| 43 | $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
|
---|
| 44 |
|
---|
| 45 | //print "<h3>ADODB Version: $ADODB_version Host: <i>$db->host</i> Database: <i>$db->database</i></h3>";
|
---|
| 46 |
|
---|
| 47 | // perform query once to cache results so we are only testing throughput
|
---|
| 48 | $rs = $db->Execute($sql);
|
---|
| 49 | if (!$rs){
|
---|
| 50 | print "Error in recordset<p>";
|
---|
| 51 | return;
|
---|
| 52 | }
|
---|
| 53 | $arr = $rs->GetArray();
|
---|
| 54 | //$db->debug = true;
|
---|
| 55 | global $ADODB_COUNTRECS;
|
---|
| 56 | $ADODB_COUNTRECS = false;
|
---|
| 57 | $start = microtime();
|
---|
| 58 | for ($i=0; $i < $max; $i++) {
|
---|
| 59 | $rs =& $db->Execute($sql);
|
---|
| 60 | $arr =& $rs->GetArray();
|
---|
| 61 | // print $arr[0][1];
|
---|
| 62 | }
|
---|
| 63 | $end = microtime();
|
---|
| 64 | $start = explode(' ',$start);
|
---|
| 65 | $end = explode(' ',$end);
|
---|
| 66 |
|
---|
| 67 | //print_r($start);
|
---|
| 68 | //print_r($end);
|
---|
| 69 |
|
---|
| 70 | // print_r($arr);
|
---|
| 71 | $total = $end[0]+trim($end[1]) - $start[0]-trim($start[1]);
|
---|
| 72 | printf ("<p>seconds = %8.2f for %d iterations each with %d records</p>",$total,$max, sizeof($arr));
|
---|
| 73 | flush();
|
---|
| 74 |
|
---|
| 75 |
|
---|
| 76 | //$db->Close();
|
---|
| 77 | }
|
---|
| 78 | include("testdatabases.inc.php");
|
---|
| 79 |
|
---|
| 80 | ?>
|
---|
| 81 |
|
---|
| 82 |
|
---|
| 83 | </body>
|
---|
| 84 | </html>
|
---|