写个循环验证下
$time1 = time();
for ($i=0; $i<=10000; $i++) {
Db::table('oa_test')->where('status',1)->select();
}
$time2 = time();
$time = $time2-$time1;
var_dump($time);
大概用时4秒。
跟这样写效果一样的
$time1 = time();
for ($i=0; $i<=10000; $i++) {
$a = db('test', [], false)->where('status',1)->select();
}
$time2 = time();
$time = $time2-$time1;
var_dump($time);
如果这么写:
$time1 = time();
for ($i=0; $i<=10000; $i++) {
$a = db('test')->where('status',1)->select();
}
$time2 = time();
$time = $time2-$time1;
var_dump($time);
直接超时报错了,所以频繁查询建议db('test', [], false)->where('status',1)->select();