标题：*
140 字

TAG标签：（用空格隔开）
30 字

恢复历史版本：

HTML转MD HTML转MD2

<pre class="brush:plain;toolbar:false">$j=1000;	
g(&#39;s1&#39;);		
echo&nbsp;&#39;来自memory数据库:&#39;;
$db&nbsp;=&nbsp;new&nbsp;PDO(&#39;mysql:host=127.0.0.1;dbname=shua_net&#39;,&nbsp;&#39;qqtxt&#39;,&nbsp;&#39;zhh1981zhh&#39;);
g(&#39;s2&#39;);
for($i=0;$i&lt;$j;$i++){$sth=$db-&gt;prepare(&#39;update&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session&nbsp;set&nbsp;session_expire=&quot;&#39;.$i.&#39;&quot;&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$sth=$db-&gt;prepare(&#39;select&nbsp;session_expire&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$a=$sth-&gt;fetchColumn();}
echo&nbsp;&#39;初始化：&#39;.g(&#39;s1&#39;,&#39;s2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;s2&#39;,&#39;s3&#39;,8);

g(&#39;ssss1&#39;);		
echo&nbsp;&#39;&lt;br&gt;来自myisam数据库:&#39;;
$db&nbsp;=&nbsp;new&nbsp;PDO(&#39;mysql:host=127.0.0.1;dbname=shua_net&#39;,&nbsp;&#39;qqtxt&#39;,&nbsp;&#39;zhh1981zhh&#39;);
g(&#39;ssss2&#39;);
for($i=0;$i&lt;$j;$i++){$sth=$db-&gt;prepare(&#39;update&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session1&nbsp;set&nbsp;session_expire=&quot;&#39;.$i.&#39;&quot;&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$sth=$db-&gt;prepare(&#39;select&nbsp;session_expire&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session1&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$d=$sth-&gt;fetchColumn();}
echo&nbsp;&#39;初始化：&#39;.g(&#39;ssss1&#39;,&#39;ssss2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;ssss2&#39;,&#39;ssss3&#39;,8);

g(&#39;sssss1&#39;);
echo&nbsp;&#39;&lt;br&gt;来自innodb(串行事务)数据库:&#39;;
$db&nbsp;=&nbsp;new&nbsp;PDO(&#39;mysql:host=127.0.0.1;dbname=shua_net&#39;,&nbsp;&#39;qqtxt&#39;,&nbsp;&#39;zhh1981zhh&#39;);
$sth=$db-&gt;prepare(&#39;set&nbsp;session&nbsp;transaction&nbsp;isolation&nbsp;level&nbsp;serializable&#39;);$sth-&gt;execute();
g(&#39;sssss2&#39;);
for($i=0;$i&lt;$j;$i++){$sth=$db-&gt;prepare(&#39;update&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session2&nbsp;set&nbsp;session_expire=&quot;&#39;.$i.&#39;&quot;&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$sth=$db-&gt;prepare(&#39;select&nbsp;session_expire&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session2&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$e=$sth-&gt;fetchColumn();}
echo&nbsp;&#39;初始化：&#39;.g(&#39;sssss1&#39;,&#39;sssss2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;sssss2&#39;,&#39;sssss3&#39;,8);

g(&#39;ssssss1&#39;);
echo&nbsp;&#39;&lt;br&gt;来自innodb(可重复读)数据库:&#39;;
$db&nbsp;=&nbsp;new&nbsp;PDO(&#39;mysql:host=127.0.0.1;dbname=shua_net&#39;,&nbsp;&#39;qqtxt&#39;,&nbsp;&#39;zhh1981zhh&#39;);
$sth=$db-&gt;prepare(&#39;set&nbsp;session&nbsp;transaction&nbsp;isolation&nbsp;level&nbsp;repeatable&nbsp;read&#39;);$sth-&gt;execute();
g(&#39;ssssss2&#39;);
for($i=0;$i&lt;$j;$i++){$sth=$db-&gt;prepare(&#39;update&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session2&nbsp;set&nbsp;session_expire=&quot;&#39;.$i.&#39;&quot;&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$sth=$db-&gt;prepare(&#39;select&nbsp;session_expire&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;session2&nbsp;where&nbsp;session_id=1&#39;);$sth-&gt;execute();$f=$sth-&gt;fetchColumn();}
echo&nbsp;&#39;初始化：&#39;.g(&#39;ssssss1&#39;,&#39;ssssss2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;ssssss2&#39;,&#39;ssssss3&#39;,8);

g(&#39;ss1&#39;);
echo&nbsp;&#39;&lt;br&gt;来自文件:&#39;;
for($i=0;$i&lt;$j;$i++)&nbsp;{file_put_contents(&#39;a.txt&#39;,$i);$b=file_get_contents(&#39;a.txt&#39;);}
echo&nbsp;g(&#39;ss1&#39;,&#39;ss2&#39;,8);

g(&#39;sss1&#39;);
echo&nbsp;&#39;&lt;br&gt;来自redis&#39;;for($i=0;$i&lt;$j;$i++)$handler=new&nbsp;Redis;&nbsp;$handler-&gt;pconnect(&#39;127.0.0.1&#39;,&nbsp;6379);
g(&#39;sss2&#39;);
for($i=0;$i&lt;$j;$i++){$handler-&gt;set(&#39;phone&#39;,$i);$c=$handler-&gt;get(&#39;phone&#39;);}
echo&nbsp;&#39;初始化：&#39;.g(&#39;sss1&#39;,&#39;sss2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;sss2&#39;,&#39;sss3&#39;,8);
echo&nbsp;&quot;&lt;br&gt;$a&lt;br&gt;$b&lt;br&gt;$c&lt;br&gt;$d&lt;br&gt;$e&lt;br&gt;&lt;br&gt;$f&lt;br&gt;&quot;;

来自memory数据库:初始化：0.00093007&nbsp;执行：0.26429486
来自myisam数据库:初始化：0.00091720&nbsp;执行：0.29974198
来自innodb(串行事务)数据库:初始化：0.00107884&nbsp;执行：3.05821395
来自innodb(可重复读)数据库:初始化：0.00145388&nbsp;执行：3.32257700
来自文件:0.45162892
来自redis初始化：0.00082207&nbsp;执行：0.20237899</pre><pre class="brush:php;toolbar:false">$j=1000;	
g(&#39;s1&#39;);		
echo&nbsp;&#39;来自数据库:&#39;;
$db&nbsp;=&nbsp;new&nbsp;PDO(&#39;mysql:host=127.0.0.1;dbname=shua_net&#39;,&nbsp;&#39;qqtxt&#39;,&nbsp;&#39;zhh1981zhh&#39;);
g(&#39;s2&#39;);
for($i=0;$iprepare(&#39;update&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;admin&nbsp;set&nbsp;username=&quot;admin&#39;.$i.&#39;&quot;&nbsp;where&nbsp;admin_id=3&#39;);$sth-&gt;execute();$sth=$db-&gt;prepare(&#39;select&nbsp;username&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;admin&nbsp;where&nbsp;admin_id=3&#39;);$sth-&gt;execute();$a=$sth-&gt;fetchColumn();}
echo&nbsp;&#39;初始化：&#39;.g(&#39;s1&#39;,&#39;s2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;s2&#39;,&#39;s3&#39;,8);

g(&#39;ss1&#39;);
echo&nbsp;&#39;
来自文件:&#39;;
for($i=0;$i&lt;$j;$i++)&nbsp;{file_put_contents(&#39;a.txt&#39;,&#39;admin&#39;.$i);$b=file_get_contents(&#39;a.txt&#39;);}
echo&nbsp;g(&#39;ss1&#39;,&#39;ss2&#39;,8);

g(&#39;sss1&#39;);
echo&nbsp;&#39;
来自redis&#39;;for($i=0;$ipconnect(&#39;127.0.0.1&#39;,&nbsp;6379);
g(&#39;sss2&#39;);
for($i=0;$iset(&#39;phone&#39;,&#39;admin&#39;.$i);$c=$handler-&gt;get(&#39;phone&#39;);}
echo&nbsp;&#39;初始化：&#39;.g(&#39;sss1&#39;,&#39;sss2&#39;,8).&#39;&nbsp;执行：&#39;.g(&#39;sss2&#39;,&#39;sss3&#39;,8);
echo&nbsp;&quot;
$a
$b
$c
&quot;;
return;

结果
来自数据库:初始化：0.00124907&nbsp;执行：3.03205800
来自文件:0.73245597
来自redis初始化：0.00031805&nbsp;执行：0.13012195
admin999
admin999
admin999

用写读来破缓冲，都是1000次，原生redis完胜</pre><pre class="brush:php;toolbar:false">echo&nbsp;&#39;
来自数据库&#39;;
for($i=0;$isingle(&#39;select&nbsp;phone&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;user&nbsp;limit&nbsp;1&#39;);
echo	&#39;
&#39;.g(&#39;s1&#39;,&#39;s2&#39;,8);
g(&#39;s3&#39;);
echo&nbsp;&#39;
来自文件&#39;;
for($i=0;$i&lt;10000;$i++)file_get_contents(&#39;b.txt&#39;);
echo	&#39;
&#39;.g(&#39;s3&#39;,&#39;s4&#39;,8);
g(&#39;s5&#39;);
echo&nbsp;&#39;
来自redis&#39;;for($i=0;$i&lt;10000;$i++)S(&#39;common_config&#39;);
echo	&#39;
&#39;.g(&#39;s5&#39;,&#39;s6&#39;,8);

&nbsp;&nbsp;来自数据库
7.55693293
来自文件
0.73415995
来自redis
0.93912983</pre><pre class="brush:php;toolbar:false">S(&#39;common_config&#39;);//事先初始化redis
g(&#39;s1&#39;);
echo&nbsp;&#39;
来自数据库&#39;;db()-&gt;single(&#39;select&nbsp;phone&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;user&nbsp;where&nbsp;uid=1&#39;);
echo	&#39;
&#39;.g(&#39;s1&#39;,&#39;s2&#39;,8);
g(&#39;s3&#39;);
echo&nbsp;&#39;
来自文件&#39;;file_get_contents(&#39;b.txt&#39;);
echo	&#39;
&#39;.g(&#39;s3&#39;,&#39;s4&#39;,8);
g(&#39;s5&#39;);
echo&nbsp;&#39;
来自redis&#39;;S(&#39;common_config&#39;);
echo	&#39;
&#39;.g(&#39;s5&#39;,&#39;s6&#39;,8);</pre>来自数据库 0.00517797 来自文件 0.00016403 来自redis事先初始化redis0.00022101 <pre class="brush:php;toolbar:false">#S(&#39;common_config&#39;);//事先不初始化redis
g(&#39;s1&#39;);
echo&nbsp;&#39;
来自数据库&#39;;db()-&gt;single(&#39;select&nbsp;phone&nbsp;from&nbsp;&#39;.C(&#39;DB_PREFIX&#39;).&#39;user&nbsp;where&nbsp;uid=1&#39;);
echo	&#39;
&#39;.g(&#39;s1&#39;,&#39;s2&#39;,8);
g(&#39;s3&#39;);
echo&nbsp;&#39;
来自文件&#39;;file_get_contents(&#39;b.txt&#39;);
echo	&#39;
&#39;.g(&#39;s3&#39;,&#39;s4&#39;,8);
g(&#39;s5&#39;);
echo&nbsp;&#39;
来自redis&#39;;S(&#39;common_config&#39;);
echo	&#39;
&#39;.g(&#39;s5&#39;,&#39;s6&#39;,8);</pre> 来自数据库 0.00493622 来自文件 0.00015497 来自redis 0.00425720