test/phptests/mysqlwqtest26.php

   1 <html>
   2 <body>
   3 <?php
   4 /*Performance Test for all parameterised DML*/
   5
   6 $conn=odbc_connect('mycsql','root','');
   7 if (!$conn)
   8   {exit("Connection Failed: " . $conn);}
   9 echo "Connection Passed\n";
  10
  11 $sth = odbc_prepare($conn,"CREATE TABLE t1 (f1 BIGINT, f2 char(196), primary key (f1));");
  12 $res = odbc_execute($sth);
  13 if (!$res)
  14   {exit("Error in Creation");}
  15 echo "Table Created\n";
  16
  17  $timecount = 0;
  18  $min = 1;
  19  $max = 0;
  20  $time_start = 0;
  21  $time_end = 0;
  22  $time = 0;
  23  $count =0;
  24  $q = "INSERT INTO t1(f1,f2) values(?,?);";
  25  $b = "ABCDEFGHIJKLMNOPQRSTUVWXYZ9876543210";
  26  $res = odbc_prepare ($conn, $q);
  27  for ($i = 0; $i <100; $i++)
  28  {
  29    $time_start = microtime();
  30    $a = $i;
  31    odbc_execute($res, array($a, $b));
  32    $time_end = microtime();
  33    $time = $time_end - $time_start;
  34    $timecount = $timecount + $time ;
  35    if ($min > $time)
  36       {$min = $time;}
  37    if ($max < $time)
  38       {$max = $time;}
  39    $count++;
  40  }
  41  printf("\nInsert :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
  42
  43 $sth = 'SELECT * FROM t1;';
  44 $rs = odbc_exec($conn, $sth);
  45 if (!$rs)
  46   {exit("Error in SQL-2");}
  47 odbc_result_all($rs, 'border = 2');
  48
  49  $timecount = 0;
  50  $min = 1;
  51  $max = 0;
  52  $time_start = 0;
  53  $time_end = 0;
  54  $time = 0;
  55  $count =0;
  56  $q = "SELECT * FROM t1 WHERE f1=?;";
  57  $res = odbc_prepare ($conn, $q);
  58  for ($i = 0; $i <100; $i++)
  59  {
  60    $time_start = microtime();
  61    $a = $i;
  62    $rs=odbc_execute($res, array($a));
  63
  64    echo "<table><tr>";
  65    echo "<th>ROLL</th>";
  66    echo "<th>NAME</th></tr>";
  67    while (odbc_fetch_row($rs))
  68    {
  69      $roll=odbc_result($rs, 1);
  70      $name=odbc_result($rs, 2);
  71      echo "<tr><td>$roll</td>";
  72      echo "<td>$name</td></tr>\n";
  73    }
  74    echo "</table>";
  75
  76    $time_end = microtime();
  77    $time = $time_end - $time_start;
  78    $timecount = $timecount + $time ;
  79    if ($min > $time)
  80       {$min = $time;}
  81    if ($max < $time)
  82       {$max = $time;}
  83    $count++;
  84  }
  85  printf("\nSelect :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
  86
  87  $timecount = 0;
  88  $min = 1;
  89  $max = 0;
  90  $time_start = 0;
  91  $time_end = 0;
  92  $time = 0;
  93  $count =0;
  94  $q = "update t1 set f2=? where f1=?;";
  95  $res = odbc_prepare ($conn, $q);
  96  for ($i = 0; $i <100; $i++)
  97  {
  98    $time_start = microtime();
  99    $a = "LAKSHYA_CSQL";
 100    $b = $i;
 101    odbc_execute($res, array($a, $b));
 102    $time_end = microtime();
 103    $time = $time_end - $time_start;
 104    $timecount = $timecount + $time ;
 105    if ($min > $time)
 106       {$min = $time;}
 107    if ($max < $time)
 108       {$max = $time;}
 109    $count++;
 110  }
 111  printf("\nUpdate :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
 112
 113 $sth = 'SELECT * FROM t1;';
 114 $rs = odbc_exec($conn, $sth);
 115 if (!$rs)
 116   {exit("Error in SQL-2");}
 117 odbc_result_all($rs, 'border = 2');
 118
 119  $timecount = 0;
 120  $min = 1;
 121  $max = 0;
 122  $time_start = 0;
 123  $time_end = 0;
 124  $time = 0;
 125  $count =0;
 126  $q = "DELETE FROM t1 WHERE f1=?;";
 127  $res = odbc_prepare ($conn, $q);
 128  for ($i = 0; $i <100; $i++)
 129  {
 130    $time_start = microtime();
 131    $a = $i;
 132    $rs = odbc_execute($res, array($a));
 133    $time_end = microtime();
 134    $time = $time_end - $time_start;
 135    $timecount = $timecount + $time ;
 136    if ($min > $time)
 137       {$min = $time;}
 138    if ($max < $time)
 139       {$max = $time;}
 140    $count++;
 141  }
 142  printf("\nDelete :%6d  MIN :%4f  MAX :%4f AVG :%4f microsec\n",$count,$min,$max,$timecount/$count);
 143
 144 $sth = 'SELECT * FROM t1;';
 145 $rs = odbc_exec($conn, $sth);
 146 if (!$rs)
 147   {exit("Error in SQL-2");}
 148 odbc_result_all($rs, 'border = 2');
 149
 150 $sth=odbc_prepare($conn,"DROP TABLE t1;");
 151 $res = odbc_execute($sth);
 152 if (!$res)
 153   {exit("\nError in Drop Table");}
 154 echo "\nTable Dropped \nTest Passed";
 155 odbc_close($conn);
 156
 157 ?>
 158 </body>
 159 </html>