Ticket #696: SC_Query.test.php

<?php
require_once('../../htdocs/require.php');
$objQuery = new SC_Query("mysql:host=localhost;dbname=hakosuke,hakosuke,hakosuke");
echo "\n==================================================================================== old method";
run(true,$objQuery);
echo "\n==================================================================================== new method";
run(false,$objQuery);

function run($old = false,$objQuery){
  $objQuery->query("TRUNCATE TABLE dtb_order");
  $starttime = microtime(true);
  echo "\n";
  flush();
  ob_flush();
  $currenttime = $starttime;
  for($i = 0;$i < 99999;$i++){
    $nextkey = $objQuery->get_auto_increment("dtb_order",$old);
    $data = array(
      "order_id" => $nextkey,
      "create_date" => date("Y-m-d H:i:s"),
      "customer_id" => "0",
      "order_temp_id" => "dfghjkjhgfghjdsfadsaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
      );
      $objQuery->insert("dtb_order",$data);
      $lasttime = $currenttime;
      $currenttime = microtime(true);
      $diff = $currenttime - $lasttime;
      echo $i.",".$diff."\n";
      flush();
      ob_flush();
  }
  echo date("Y-m-d H:i:s");
}