需要執(zhí)行5條查詢sql,每條sql執(zhí)行時間為2s,同步的情況需要10s,有什么方案辦法能優(yōu)化一下嗎?
隨便寫了一個demo
public function test(Request $request)
{
$time = time();
$sqlArr =[
'select sleep(2);',
'select sleep(2);',
'select sleep(2);',
'select sleep(2);',
'select sleep(2);',
];
foreach ($sqlArr as $sql){
Db::select($sql);
}
return json(['code' => 0, 'msg' => 'ok','tt'=>time()-$time]);
}
{
"code": 0,
"msg": "ok",
"tt": 10
}
給你兩條路: