目前我正在使用两个查询-一个用于重试日期,一个用于holddate.如果我们合并这两个查询&在单个查询中获得结果,那么它会提供更好的性能吗?如果是这样,如何合并?
1st查询:
$sql = "SELECT employeename, DATE(reattemptdate) as date,
COUNT(*) as count FROM orders
WHERE DATE(reattemptdate) = CURDATE()
GROUP BY employeename, date";
$results = $db_handle->runSelectQuery($sql);
$numrowsresult =$results[0]['count'];
foreach ($results as $result)
{
echo $result['employeename'].'|'.$result['date'].'|'.$result['count']."
";
}
echo "
";2nd查询:
$sqla = "SELECT employeename, DATE(holddate) as date,
COUNT(*) as count FROM orders
WHERE DATE(holddate) = CURDATE()
GROUP BY employeename, date";
$resultsa = $db_handle->runSelectQuery($sqla);
$numrowsresulta =$resultsa[0]['count'];
foreach ($resultsa as $resulta)
{
echo $resulta['employeename'].'|'.$resulta['date'].'|'.$resulta['count']."
";
}
echo "
";发布于 2018-09-10 13:09:28
如果我们合并这两个查询&在单个查询中获得结果,那么它会提供更好的性能吗?
不是的。
https://codereview.stackexchange.com/questions/203476
复制相似问题