Benchmark: APC vs. MySQL MEMORY fetching Speed

// Simple test script benchmarking cache access times
// of APC and MySQL MEMORY
// by: Julius Beckmann (juliusbeckmann.de)

// Config
$n = 10000;
$newline = "<br/>\n";

// Init benchmark array with $n entrys
$array = array();
$i = 0;
while($i++ < $n) {
  $array[] = rand(0,999999);
}

echo "Testarray has ".count($array)." random integer entrys".$newline;

// Check direct array access time
$time_start = microtime(true);
$i = 0;
while($i < $n) {
  $devnull = $array[$i++];
}
$time_end = microtime(true);
$time = $time_end-$time_start;
echo number_format($time, 3, '.', '')
  ." seconds - direct array access".$newline;
 

// Adding these array values to APC
foreach($array as $k => $v) {
  apc_store('test_'.$k, $v);
}
// Benchmarking apc_fetch
$time_start = microtime(true);
$i = 0;
$count = count($array);
while($i < $count) {
  $devnull = apc_fetch('test_'.$i++);
}
$time_end = microtime(true);
$time = $time_end-$time_start;
echo number_format($time, 3, '.', '')
  ." seconds - apc_fetch()".$newline;
// Deleting APC entrys
foreach($array as $k => $v) {
  apc_delete('test_'.$k);
}

// Benchmark mysql

// Connect
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) die('Not connected : ' . mysql_error());
$db_selected = mysql_select_db('database', $link);
if (!$db_selected) die ('Can\'t use foo : ' . mysql_error());
   
// Adding these array values to mySQL Memory table
/* TABLE:
 CREATE TABLE `test_memory` (
`key` INT UNSIGNED NOT NULL ,
`value` INT UNSIGNED NOT NULL
) ENGINE = MEMORY
*/
foreach($array as $k => $v) {
  mysql_query('INSERT INTO test_memory (`key`,`value`) VALUES ('.$k.', '.$v.');');
}
// Benchmark mysql memory table
$time_start = microtime(true);
$i = 0;
$count = count($array);
while($i < $count) {
  list(,$devnull) = mysql_fetch_row(mysql_query('SELECT * FROM `test_memory` WHERE `key` ='.$i++.';'));
}
$time_end = microtime(true);
$time = $time_end-$time_start;
echo number_format($time, 3, '.', '')
  ." seconds - mysql_query from MEMORY table FIRST RUN".$newline;
// Benchmark a second time to check for mysql caches
$time_start = microtime(true);
$i = 0;
$count = count($array);
while($i < $count) {
  list(,$devnull) = mysql_fetch_row(mysql_query('SELECT * FROM `test_memory` WHERE `key` ='.$i++.';'));
}
$time_end = microtime(true);
$time = $time_end-$time_start;
echo number_format($time, 3, '.', '')
  ." seconds - mysql_query from MEMORY table SECOND RUN".$newline;
// Trunc memory table
mysql_query('TRUNCATE TABLE test_memory;');

?>