drm16022 2018-06-14 10:36
浏览 46

php存储mysql结果到memcache

I have a large amount of fetched rows in mysql table, it takes plenty of time to load the result everytime when the page is call, I might want to cache the result into php memcached to save loading time for every queries once the page loaded.

let say the query function is call:

class Account
{
    public function get_account($mysqli)
    {
        $q  = "SELECT * ";
        $q .= "FROM `account`";

        $sql = $mysqli->query($q);

        if($sql->num_rows !== 0){
            return $sql;
        }
        return false;
    }

}

request the result:

$acc = new Account;
$m = new Memcache;

$m->addServer('localhost', 11211);

$ls = $acc->get_account($mysqli);

$html = '';
while($ob = $ls->fetch_object()){
   $html .= '
                <tr>
                    <td>'.$ob->name.'</td>
                    <td>'.$ob->phone.'</td>
                    <td>'.$ob->email.'</td>
                    <td>'.$ob->country.'</td>
                </tr>';
}

in this case, how can I store the result into memcached? how can memcached know this result is stored and no MySQL query needed to load again?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用C#,asp.net读取Excel文件并保存到Oracle数据库
    • ¥15 C# datagridview 单元格显示进度及值
    • ¥15 thinkphp6配合social login单点登录问题
    • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
    • ¥15 如何在scanpy上做差异基因和通路富集?
    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配