表hk_order(id,code,client_id,prices,shr,zdr,yes_sh,date1,falg) [有1000条记录]
表hk_order_prod(code,yes_sum,yes_pay) [有10000条记录]
查询语句:
$sql="select hk_order.id as crk_id,hk_order.code as crk_code,hk_order.client_id,hk_order.prices,hk_order.shr,hk_order.zdr,hk_order.yes_sh,hk_order.date1,hk_order.falg,hk_order_prod.code,hk_order_prod.yes_sum
from hk_order,hk_order_prod
where hk_order.code=hk_order_prod.code and hk_order_prod.yes_sum='yes' and hk_order_prod.yes_pay='no' and hk_order.yes_sh='yes'";这条语句在mysql上执行需4秒时间,问问各位怎么可以优化....谢谢...
表hk_order_prod(code,yes_sum,yes_pay) [有10000条记录]
查询语句:
$sql="select hk_order.id as crk_id,hk_order.code as crk_code,hk_order.client_id,hk_order.prices,hk_order.shr,hk_order.zdr,hk_order.yes_sh,hk_order.date1,hk_order.falg,hk_order_prod.code,hk_order_prod.yes_sum
from hk_order,hk_order_prod
where hk_order.code=hk_order_prod.code and hk_order_prod.yes_sum='yes' and hk_order_prod.yes_pay='no' and hk_order.yes_sh='yes'";这条语句在mysql上执行需4秒时间,问问各位怎么可以优化....谢谢...
from hk_order left jion hk_order_prod on hk_order.code=hk_order_prod.code
where hk_order_prod.yes_sum='yes' and hk_order_prod.yes_pay='no' and hk_order.yes_sh='yes'
这样?
你这种我想应该要快点的吧..先筛选再联接.....