1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
|
//**************************
//**************************
// *** PARAMETRAGES
$enregistrement_max = 10000;
$requete_max = 10;
$base = "engine_test";
$table_temp = "table_test";
$engine_array = array("ENGINE = MYISAM","ENGINE = MEMORY");
//$engine = "ENGINE = MYISAM";
//**************************
//**************************
foreach($engine_array as $engine)
{
print "<br>ENGINE => ".$engine;
$t1 = mktime();
//*******************
mysql_query("DROP DATABASE $base");
mysql_query("CREATE DATABASE $base") or die(mysql_error());
//*******************
//$table_source = "20090130_produit_pamimu";
mysql_db_query($base,"DROP TABLE `$table_temp`");
mysql_db_query($base,"CREATE TABLE `$table_temp` (
`id` INT( 7 ) NOT NULL ,
`x` INT( 15 ) NULL ,
`y` INT( 15 ) NULL ,
`z` INT( 15 ) NULL ,
`o` INT( 15 ) NULL ,
INDEX (
`id`
)
) $engine ") or die(mysql_error());
// *** On rempli la base avec des valeurs quelconques
$id = 0;
$enregistrement_max_i = $enregistrement_max;
while($enregistrement_max_i > 0)
{
$id++;
$x = rand(1000000,9000000);
$y = rand(1000000,9000000);
$z = rand(1000000,9000000);
$o = rand(1000000,9000000);
mysql_db_query($base,"INSERT INTO `$table_temp` (id,x,y,z,o) VALUES ('$id','$x','$y','$z','$o')") or die(mysql_error());
$enregistrement_max_i--;
}
$t2=mktime();
//print '<br>timestamp = '.$t2;
print '<br>ecart='.($t2-$t1);
$requete_max_i = $requete_max;
while($requete_max_i > 0)
{
$update_req = mysql_db_query($base,"SELECT * FROM `$table_temp`") or die(mysql_error());
while($update_data = mysql_fetch_array($update_req))
{
$u_x = rand(1000000,9000000);
$u_y = rand(1000000,9000000);
$u_z = rand(1000000,9000000);
$u_o = rand(1000000,9000000);
mysql_db_query($base,"UPDATE `$table_temp` SET x = '$u_x', y = '$u_y', z= '$u_z', o = '$u_o' WHERE id ='$update_data[id]'") or die(mysql_error());
$enregistrement_max_i--;
}
$requete_max_i--;
}
// TEST CONTROLE
$test_req = mysql_db_query($base,"SELECT * FROM `$table_temp` WHERE id='".($enregistrement_max-10)."'") or die(mysql_error());
$test_data = mysql_fetch_array($test_req);
print '<br>TEST = '.$test_data[id].'-'.mysql_num_rows($test_req);
//***********************
$t3=mktime();
//print '<br>timestamp = '.$t3;
print '<br>ecart='.($t3-$t2);
print '<br>ecart='.($t3-$t1);
} |
Partager