<?php
require('sql.php');

$category = array("ITEM_DEJI",  "ITEM_KADEN","ITEM_PC",
		  "ITEM_OFICE", "ITEM_CDVD");

for ($i=0; $i<count($category); $i++) {
     $sql[$i] = "SELECT * FROM $category[$i]";
}

// ここを変更 " UNION " <-> " UNION ALL "
$sql = implode(" UNION ", $sql);

$con  = start_connect();

create_view($con, $sql, "s_table");
$st      = 1;
$max_ros = 10;

$sum = 0;
for ($i=0; $i<10; $i++) {
     $Stime = getmicrotime();

     list($ros, $res) = select_range_data($con, "s_table", $st, $st+$max_ros-1);
     $Etime = getmicrotime();
     $sum += $Etime-$Stime;
     echo sprintf("%02d:  %1.5f秒\n", $i+1, $Etime-$Stime);
}
echo sprintf("sum: %1.5f秒\n", $sum);

?>