$j=1000;
g('s1');
echo '来自memory数据库:';
$db = new PDO('mysql:host=127.0.0.1;dbname=shua_net', 'qqtxt', 'zhh1981zhh');
g('s2');
for($i=0;$i<$j;$i++){$sth=$db->prepare('update '.C('DB_PREFIX').'session set session_expire="'.$i.'" where session_id=1');$sth->execute();$sth=$db->prepare('select session_expire from '.C('DB_PREFIX').'session where session_id=1');$sth->execute();$a=$sth->fetchColumn();}
echo '初始化:'.g('s1','s2',8).' 执行:'.g('s2','s3',8);
g('ssss1');
echo '<br>来自myisam数据库:';
$db = new PDO('mysql:host=127.0.0.1;dbname=shua_net', 'qqtxt', 'zhh1981zhh');
g('ssss2');
for($i=0;$i<$j;$i++){$sth=$db->prepare('update '.C('DB_PREFIX').'session1 set session_expire="'.$i.'" where session_id=1');$sth->execute();$sth=$db->prepare('select session_expire from '.C('DB_PREFIX').'session1 where session_id=1');$sth->execute();$d=$sth->fetchColumn();}
echo '初始化:'.g('ssss1','ssss2',8).' 执行:'.g('ssss2','ssss3',8);
g('sssss1');
echo '<br>来自innodb(串行事务)数据库:';
$db = new PDO('mysql:host=127.0.0.1;dbname=shua_net', 'qqtxt', 'zhh1981zhh');
$sth=$db->prepare('set session transaction isolation level serializable');$sth->execute();
g('sssss2');
for($i=0;$i<$j;$i++){$sth=$db->prepare('update '.C('DB_PREFIX').'session2 set session_expire="'.$i.'" where session_id=1');$sth->execute();$sth=$db->prepare('select session_expire from '.C('DB_PREFIX').'session2 where session_id=1');$sth->execute();$e=$sth->fetchColumn();}
echo '初始化:'.g('sssss1','sssss2',8).' 执行:'.g('sssss2','sssss3',8);
g('ssssss1');
echo '<br>来自innodb(可重复读)数据库:';
$db = new PDO('mysql:host=127.0.0.1;dbname=shua_net', 'qqtxt', 'zhh1981zhh');
$sth=$db->prepare('set session transaction isolation level repeatable read');$sth->execute();
g('ssssss2');
for($i=0;$i<$j;$i++){$sth=$db->prepare('update '.C('DB_PREFIX').'session2 set session_expire="'.$i.'" where session_id=1');$sth->execute();$sth=$db->prepare('select session_expire from '.C('DB_PREFIX').'session2 where session_id=1');$sth->execute();$f=$sth->fetchColumn();}
echo '初始化:'.g('ssssss1','ssssss2',8).' 执行:'.g('ssssss2','ssssss3',8);
g('ss1');
echo '<br>来自文件:';
for($i=0;$i<$j;$i++) {file_put_contents('a.txt',$i);$b=file_get_contents('a.txt');}
echo g('ss1','ss2',8);
g('sss1');
echo '<br>来自redis';for($i=0;$i<$j;$i++)$handler=new Redis; $handler->pconnect('127.0.0.1', 6379);
g('sss2');
for($i=0;$i<$j;$i++){$handler->set('phone',$i);$c=$handler->get('phone');}
echo '初始化:'.g('sss1','sss2',8).' 执行:'.g('sss2','sss3',8);
echo "<br>$a<br>$b<br>$c<br>$d<br>$e<br><br>$f<br>";
来自memory数据库:初始化:0.00093007 执行:0.26429486
来自myisam数据库:初始化:0.00091720 执行:0.29974198
来自innodb(串行事务)数据库:初始化:0.00107884 执行:3.05821395
来自innodb(可重复读)数据库:初始化:0.00145388 执行:3.32257700
来自文件:0.45162892
来自redis初始化:0.00082207 执行:0.20237899$j=1000;
g('s1');
echo '来自数据库:';
$db = new PDO('mysql:host=127.0.0.1;dbname=shua_net', 'qqtxt', 'zhh1981zhh');
g('s2');
for($i=0;$iprepare('update '.C('DB_PREFIX').'admin set username="admin'.$i.'" where admin_id=3');$sth->execute();$sth=$db->prepare('select username from '.C('DB_PREFIX').'admin where admin_id=3');$sth->execute();$a=$sth->fetchColumn();}
echo '初始化:'.g('s1','s2',8).' 执行:'.g('s2','s3',8);
g('ss1');
echo '
来自文件:';
for($i=0;$i<$j;$i++) {file_put_contents('a.txt','admin'.$i);$b=file_get_contents('a.txt');}
echo g('ss1','ss2',8);
g('sss1');
echo '
来自redis';for($i=0;$ipconnect('127.0.0.1', 6379);
g('sss2');
for($i=0;$iset('phone','admin'.$i);$c=$handler->get('phone');}
echo '初始化:'.g('sss1','sss2',8).' 执行:'.g('sss2','sss3',8);
echo "
$a
$b
$c
";
return;
结果
来自数据库:初始化:0.00124907 执行:3.03205800
来自文件:0.73245597
来自redis初始化:0.00031805 执行:0.13012195
admin999
admin999
admin999
用写读来破缓冲,都是1000次,原生redis完胜echo '
来自数据库';
for($i=0;$isingle('select phone from '.C('DB_PREFIX').'user limit 1');
echo '
'.g('s1','s2',8);
g('s3');
echo '
来自文件';
for($i=0;$i<10000;$i++)file_get_contents('b.txt');
echo '
'.g('s3','s4',8);
g('s5');
echo '
来自redis';for($i=0;$i<10000;$i++)S('common_config');
echo '
'.g('s5','s6',8);
来自数据库
7.55693293
来自文件
0.73415995
来自redis
0.93912983S('common_config');//事先初始化redis
g('s1');
echo '
来自数据库';db()->single('select phone from '.C('DB_PREFIX').'user where uid=1');
echo '
'.g('s1','s2',8);
g('s3');
echo '
来自文件';file_get_contents('b.txt');
echo '
'.g('s3','s4',8);
g('s5');
echo '
来自redis';S('common_config');
echo '
'.g('s5','s6',8);来自数据库
0.00517797
来自文件
0.00016403
来自redis事先初始化redis
0.00022101
#S('common_config');//事先不初始化redis
g('s1');
echo '
来自数据库';db()->single('select phone from '.C('DB_PREFIX').'user where uid=1');
echo '
'.g('s1','s2',8);
g('s3');
echo '
来自文件';file_get_contents('b.txt');
echo '
'.g('s3','s4',8);
g('s5');
echo '
来自redis';S('common_config');
echo '
'.g('s5','s6',8);来自数据库
0.00493622
来自文件
0.00015497
来自redis
0.00425720
