我有一个相当低效的MySQL查询,直到最近随着数据库大小的增长,它一直工作得很好。我试图使用ORDER BY RAND()语法选择一个随机记录,但它非常慢(30+秒),并导致我的PHP脚本出现问题。有没有一种更有效的方式来编写这个查询?
SELECT * FROM accountcampaign, accounts WHERE
accountcampaign.status='ACTIVE'
AND accountcampaign.dateLocked IS NULL
AND accountcampaign.campaignID='1'
AND ( (accountcampaign.lockedIPAddress IS NULL)
OR (accountcampaign.lockedIPAddress='')
)
AND ( (accountcampaign.dateLastEntry IS NULL)
OR (DATE(accountcampaign.dateLastEntry) < DATE(NOW()))
)
ORDER BY RAND() LIMIT 1发布于 2012-05-23 17:37:17
https://stackoverflow.com/questions/10717016
复制相似问题