4 /*Performance Test for all parameterised DML*/
6 //$conn=odbc_connect('myodbc3','root','');
7 $conn=odbc_connect('mycsql','root','manager');
9 {exit("Connection Failed: " . $conn);}
10 echo "Connection Passed\n";
12 $sth = odbc_prepare($conn,"CREATE TABLE t1 (f1 BIGINT, f2 char(196), primary key (f1));");
13 $res = odbc_execute($sth);
15 {exit("Error in Creation");}
16 echo "Table Created\n";
25 $q = "INSERT INTO t1(f1,f2) values(?,?);";
26 $b = "ABCDEFGHIJKLMNOPQRSTUVWXYZ9876543210";
27 $res = odbc_prepare ($conn, $q);
28 for ($i = 0; $i <100; $i++
)
30 $time_start = microtime();
32 odbc_execute($res, array($a, $b));
33 $time_end = microtime();
34 $time = $time_end - $time_start;
35 $timecount = $timecount +
$time ;
42 printf("\nInsert :%6d MIN :%4f MAX :%4f AVG :%4f \n",$count,$min,$max,$timecount/$count);
44 /*$sth = 'SELECT * FROM t1;';
45 $rs = odbc_exec($conn, $sth);
47 {exit("Error in SQL-2");}
48 odbc_result_all($rs, 'border = 2');
58 $q = "SELECT * FROM t1 WHERE f1=?;";
59 $res = odbc_prepare ($conn, $q);
60 for ($i = 0; $i <100; $i++
)
62 $time_start = microtime();
64 $rs=odbc_execute($res, array($a));
66 while (odbc_fetch_row($res))
68 //$roll=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($res, 1));
69 $roll=odbc_result($res, 1);
70 //$name=preg_replace('/[\x00-\x09\x0B-\x19\x7F]/', '',odbc_result($res, 2));
71 $name=odbc_result($res, 2);
74 $time_end = microtime();
75 $time = $time_end - $time_start;
76 $timecount = $timecount +
$time ;
83 printf("\nSelect :%6d MIN :%4f MAX :%4f AVG :%4f \n",$count,$min,$max,$timecount/$count);
92 $q = "update t1 set f2=? where f1=?;";
93 $res = odbc_prepare ($conn, $q);
94 for ($i = 0; $i <100; $i++
)
96 $time_start = microtime();
99 odbc_execute($res, array($a, $b));
100 $time_end = microtime();
101 $time = $time_end - $time_start;
102 $timecount = $timecount +
$time ;
109 printf("\nUpdate :%6d MIN :%4f MAX :%4f AVG :%4f \n",$count,$min,$max,$timecount/$count);
112 $sth = 'SELECT * FROM t1;';
113 $rs = odbc_exec($conn, $sth);
115 {exit("Error in SQL-2");}
116 odbc_result_all($rs, 'border = 2');
126 $q = "DELETE FROM t1 WHERE f1=?;";
127 $res = odbc_prepare ($conn, $q);
128 for ($i = 0; $i <100; $i++
)
130 $time_start = microtime();
132 $rs = odbc_execute($res, array($a));
133 $time_end = microtime();
134 $time = $time_end - $time_start;
135 $timecount = $timecount +
$time ;
142 printf("\nDelete :%6d MIN :%4f MAX :%4f AVG :%4f \n",$count,$min,$max,$timecount/$count);
145 $sth = 'SELECT * FROM t1;';
146 $rs = odbc_exec($conn, $sth);
148 {exit("Error in SQL-2");}
149 odbc_result_all($rs, 'border = 2');
152 $sth=odbc_prepare($conn,"DROP TABLE t1;");
153 $res = odbc_execute($sth);
155 {exit("\nError in Drop Table");}
156 echo "\nTable Dropped \nTest Passed";