Timeline for Joining subqueries with GROUP is slow
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 5, 2017 at 18:02 | comment | added | Rick James |
Did you also add the indexes? After doing so, some of the numbers in EXPLAIN might go down.
|
|
| May 5, 2017 at 9:52 | comment | added | Dalendrion | I edited my question to include the final answer. I'd vote up, but apparently I lack the reputation to do so. :( | |
| May 5, 2017 at 9:51 | vote | accept | Dalendrion | ||
| May 5, 2017 at 9:47 | comment | added | Dalendrion |
Plan A is what I did. The query is now ``` SELECT ... FROM ( ... ) voc LEFT JOIN call c on (c.start BETWEEN '2017-02-04' AND '2017-05-04') AND c.duration > 0 AND c.calltype = 'out' AND voc.user_id = c.user_id GROUP BY voc.user_id; ```
|
|
| May 4, 2017 at 18:05 | history | answered | Rick James | CC BY-SA 3.0 |