Lack of interest Reduce the number of queries when sending alerts by 33%

[021]

It turned out that for each user 4 extra queries are made, which can be combined into one using left join.

 

[Stuart Wright]

It turned out that for each user 4 extra queries are made, which can be combined into one using left join.
View attachment 283029

What's the left join query and the run time?

 

[Arantor]

I’d also note that that list of queries references two different users, so from that sample, you’re talking +2 not +3 queries.

Likely the code that is calling this could be rethought since it probably doesn’t need to call “get me everything for user 487101” then “get me everything for user 487102” but “get me everything for users 487101 and 487102” but as Stuart was hinting at, proper benchmarking will help.