select 20000条数据,获取memcache缓存内容,正常显示。
但是 select 25000条数据,获取memcache缓存内容,结果为bool(false);简单点说,就是搜索结果内容过大,无法生成memcache缓存。期待各位高手指点,谢谢。memcahcephp
但是 select 25000条数据,获取memcache缓存内容,结果为bool(false);简单点说,就是搜索结果内容过大,无法生成memcache缓存。期待各位高手指点,谢谢。memcahcephp
//连接
$mem = new Memcache;
$mem->connect("127.0.0.1", 11211) or die ("Could not connect");
print_r($mem->getStats());
echo "<br>";
$q="select * from uploadfile"; //数据有28000条
$key=md5($q);if(!($datas=$mem->get($key)))
{
echo "Read datas from MySQL<br>";
$rs=$db_oa->Execute($q);
while(!$rs->EOF)
{
$ss.=$rs->f("fileonsvrname")."<br>";
$rs->Movenext();
}
$mem->set($key, $ss, 0, 20); //set 设置无效 (问题所在)
$datas = $mem->get($key);
}
else
{
echo "Read datas from memcached<br>";
}
var_dump($datas); //输出结果是(Array ( [pid] => 1612 [uptime] => 21152 [time] => 1366094659 [version] => 1.2.6 [pointer_size] => 32 [curr_items] => 2 [total_items] => 11 [bytes] => 1401127 [curr_connections] => 2 [total_connections] => 39 [connection_structures] => 3 [cmd_get] => 50 [cmd_set] => 11 [get_hits] => 33 [get_misses] => 17 [evictions] => 0 [bytes_read] => 14237871 [bytes_written] => 21454105 [limit_maxbytes] => 67108864 [threads] => 1 )
Read datas from MySQL
bool(false) )
如果只是想加快检索的速度,那么用内存表就是了。ENGINE=MEMORY
速度至少提高一个人数量级从 memcache 中检索出需要的内容,可不是一件容易的事情