";
else
echo "Connect failure
";
flush();
$sql = "INSERT INTO foo2a (f1,f2) VALUES (1,2)";
$starttime = time();
for ($i = 0; $i < $loopcount; $i++)
$result = pg_query($conn, $sql);
$endtime = time();
$elapsed = ($endtime - $starttime);
if ($result)
echo "single-INSERT-multi-statement Elapsed time is $elapsed seconds
";
else
echo pg_last_notice($conn);
flush();
$sql = "";
for ($i = 0; $i < $loopcount; $i++)
$sql .= "INSERT INTO foo2b (f1,f2) VALUES (1,2);";
$starttime = time();
$result = pg_query($conn, $sql);
$endtime = time();
$elapsed = ($endtime - $starttime);
if ($result)
echo "single-INSERT-at-once Elapsed time is $elapsed seconds
";
else
echo pg_last_notice($conn);
flush();
$sql = "INSERT INTO foo2c (f1,f2) VALUES (1,2)";
for ($i = 1; $i < $loopcount; $i++)
$sql .= ",(1,2)";
$starttime = time();
$result = pg_query($conn, $sql);
$endtime = time();
$elapsed = ($endtime - $starttime);
if ($result)
echo "multi-INSERT-at-once Elapsed time is $elapsed seconds
";
else
echo pg_last_notice($conn);
flush();
pg_close($conn);
?>