由于 WHERE 过滤器，来自多个表的 MySQL 请求变慢

发布于 2024-12-05 15:58:24 字数 284 浏览 0 评论 0原文

我使用请求从 10 个表中选择数据，最后我有 WHERE 和 2 个条件第一个很简单，但第二个即使没有返回结果，速度也会大大减慢。

AND (eligible_users.id IS NULL OR 
((eligible_users.program = 3 AND eligible_users.status = 0) 
OR eligible_users.status = 35))

当我删除它时，页面加载速度非常快，是否有某种方法可以使其更快，但仍然保留此过滤器，因为我需要它。

原文

I am using request to select data from 10 tables and at the end i have WHERE and 2 conditions
first one is simple but with second one it slows down dramatically even when there is no results returned.

AND (eligible_users.id IS NULL OR 
((eligible_users.program = 3 AND eligible_users.status = 0) 
OR eligible_users.status = 35))

When i remove it, page loads much fast, is there some way to make it faster but still keep this filter because i need it.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

故事灯 2024-12-12 15:58:24

查询中有 3 个 OR 语句，尝试将它们拆分为 1 个或多个联合，如下所示：

select ...
where ... 
eligible_users.id IS NULL 
UNION
select ...
where ...
(eligible_users.program = 3 AND eligible_users.status = 0) 
OR eligible_users.status = 35

You have 3 OR statements in the query, try splitting them into 1 or more unions like so:

select ...
where ... 
eligible_users.id IS NULL 
UNION
select ...
where ...
(eligible_users.program = 3 AND eligible_users.status = 0) 
OR eligible_users.status = 35

回复收藏 0 原文