PHP mysqlnd svn commit: r212 - trunk/ext/mysqli/tests/bench/micro_benches

[uwendel]

Author: uwendel
Date: 2007-03-20 16:09:43 +0100 (Tue, 20 Mar 2007)
New Revision: 212

Added:
   trunk/ext/mysqli/tests/bench/micro_benches/mysqli_skeleton.php
Log:
A skeleton for those - like me - that forget the glory syntax details


Added: trunk/ext/mysqli/tests/bench/micro_benches/mysqli_skeleton.php
===================================================================
--- trunk/ext/mysqli/tests/bench/micro_benches/mysqli_skeleton.php	2007-03-20 15:09:00 UTC
(rev 211)
+++ trunk/ext/mysqli/tests/bench/micro_benches/mysqli_skeleton.php	2007-03-20 15:09:43 UTC
(rev 212)
@@ -0,0 +1,64 @@
+<?PHP
+/* Config settings should go at the very beginning */
+$rows = 10;
+
+// Set a description
+$description = 'This is a skeleton for a benchmark that does nothing.';
+
+
+/*
+  This is a hash that stores the runtimes
+  It is dumped in all reports. The hash keys will be used as labels/descriptions. 
+  $times['select()'] = 0.01; => shown in reports like 'select() : 0.01s'
+*/
+$times = array();
+/*
+  It's recommended to initialize the times hash with 0 values
+  for all entries. This often makes debugging easier. 
+  Make sure you have one 'overall' entry in your list which 
+  holds the 'entire runtime' of you test (e.g. create table + insert + select) and not
only 
+  a fraction of it (e.g. select).
+*/
+$times['overall'] = 0;
+$times['select'] = 0;
+
+/*
+  List of errors that happened during the test run. You should stop
+  the benchmark after the first error
+*/
+$errors = array();
+
+
+do {
+  
+  $times['overall'] = microtime(true);
+  
+  /*
+    Use this to connect to the database. The variables $host, ... 
+    $socket and $flag_original_code are provided by the framework  
+  */
+  if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
+    
+    $errors[] = sprintf("Connect failure (converted code: %s)\n", ($flag_original_code) ?
'no' : 'yes');
+    break;
+  }
+  
+  for ($i =  0; $i < $rows; $i++) {
+    
+    $start = microtime(true);
+    if (!$res = mysqli_query($link, "SELECT $i")) {
+      $errors[] = sprintf("SELECT failed for row = %d (converted code: %s)\n", 
+        $i,
+        ($flag_original_code) ? 'no' : 'yes');
+      break 2;
+    }
+    $times['select'] += (microtime(true) - $start);   
+    
+    mysqli_free_result($res);    
+  }  
+
+  mysqli_close($link);
+  $times['overall'] = (microtime(true) - $times['overall']);
+  
+} while (false);
+?>
\ No newline at end of file