Wpisuje dane do pusych baz danych, zlozonych z 3 kolumn. Tabele są identyczne w każdej bazie danych.
Kod Mysql
Kod
<?php
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}
$connect=mysql_connect("localhost", "root", "haslo") or die("Sprawdz połączenie z serwerem");
mysql_select_db("osoby");
$time_start =microtime_float();
for($i=1; $i<=1000; $i++)
{
$sql="INSERT INTO `inserto` (`Imie` , `Nazwisko` , `Miasto` )
VALUES ('Jan', 'Patrykowski', 'Tczew'
)";
if (!mysql_query($sql,$connect))
{
die('Error: ' . mysql_error());
}
}
echo "records added";
$time_end =microtime_float();
echo $time_end -$time_start;
mysql_close($connect)
?>
Kod Oracle
Kod
<?php
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}
$connect = oci_connect("system", "haslo");
$time_start =microtime_float();
for($i=1; $i<=1000; $i++)
{
$stmt = oci_parse($connect, "INSERT INTO inserto(IMIE, NAZWISKO, MIASTO) VALUES ('Jan', 'Patrykowski', 'Tczew')");
oci_execute($stmt);
}
echo "records added";
$time_end =microtime_float();
echo $time_end -$time_start;
?>
Kod Access
Kod
<?
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}
$dsn = "access";
$user = "Admin";
$password = "rybka";
$link = odbc_connect($dsn,$user,$password)
or die ('dupa z polaczenia ');
$time_start =microtime_float();
for($i=1; $i<=1000; $i++)
{
$query = "INSERT INTO `inserto` (`IMIE`, `NAZWISKO`, `MIASTO`) VALUES ('Jan', 'Patrykowski', 'Tczew' )";
$result= odbc_exec($link,$query);
}
echo "records added";
$time_end =microtime_float();
echo $time_end -$time_start;
?>