SELECT * FROM `sale_orders` T
WHERE (`number`='' or `number`=81)
AND 1=(select count(*) from `sale_orders`
where (`number`='' or `number`=81)
AND `recipient_name`=T.`recipient_name`
AND `ship_address_1`=T.`ship_address_1`)
AND
`package_area`='SZ'
GROUP BY `recipient_name` , `ship_address_1`以上语句当查询的记录到1700条的时候,执行需要35秒左右,有没有什么方法能够让它快点?这还只是一个语句
我还循环15次
WHERE (`number`='' or `number`=81)
AND 1=(select count(*) from `sale_orders`
where (`number`='' or `number`=81)
AND `recipient_name`=T.`recipient_name`
AND `ship_address_1`=T.`ship_address_1`)
AND
`package_area`='SZ'
GROUP BY `recipient_name` , `ship_address_1`以上语句当查询的记录到1700条的时候,执行需要35秒左右,有没有什么方法能够让它快点?这还只是一个语句
我还循环15次
create index xx2 on sale_orders (number,recipient_name,ship_address_1)
number是int