<?php
$countries = \Yii::$app->db->createCommand('SELECT * FROM country')->queryAll();
$cities = \Yii::$app->db->createCommand('SELECT * FROM city WHERE country_id=20')->queryAll();

$dbCache = \Yii::$app->dbCache;
$dbCache->flush();
$dbCache->set('countries', $countries);
$dbCache->set('cities', $cities);

$fileCache = \Yii::$app->fileCache;
$fileCache->flush();
$fileCache->set('countries', $countries);
$fileCache->set('cities', $cities);

$memcache = \Yii::$app->memcache;
$memcache->flush();
$memcache->set('countries', $countries);
$memcache->set('cities', $cities);

$redisCache = \Yii::$app->redisCache;
//$redisCache->flush();
$redisCache->set('countries', $countries);
$redisCache->set('cities', $cities);


// DB
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $dbCache->get('countries');
}
$res['dbCache']['1000_small'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $dbCache->get('countries');
}
$res['dbCache']['10000_small'] = microtime(true) - $start;

// File
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $fileCache->get('countries');
}
$res['fileCache']['1000_small'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $fileCache->get('countries');
}
$res['fileCache']['10000_small'] = microtime(true) - $start;
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $fileCache->get('cities');
}
$res['fileCache']['1000_big'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $fileCache->get('cities');
}
$res['fileCache']['10000_big'] = microtime(true) - $start;

// Redis
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $redisCache->get('countries');
}
$res['redisCache']['1000_small'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $redisCache->get('countries');
}
$res['redisCache']['10000_small'] = microtime(true) - $start;
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $redisCache->get('cities');
}
$res['redisCache']['1000_big'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $redisCache->get('cities');
}
$res['redisCache']['10000_big'] = microtime(true) - $start;


// Memcached
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $memcache->get('countries');
}
$res['memcache']['1000_small'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $memcache->get('countries');
}
$res['memcache']['10000_small'] = microtime(true) - $start;
$start = microtime(true);
for($i=0; $i<1000; $i++) {
    $memcache->get('cities');
}
$res['memcache']['1000_big'] = microtime(true) - $start;

$start = microtime(true);
for($i=0; $i<10000; $i++) {
    $memcache->get('cities');
}
$res['memcache']['10000_big'] = microtime(true) - $start;