Timeline for MySQL Query optimisation advice
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 23, 2017 at 9:14 | vote | accept | dlearious | ||
| Mar 8, 2017 at 21:31 | comment | added | Rick James | This needs to be a learning exercise for you, too, but I added some more hints. | |
| Mar 8, 2017 at 21:30 | history | edited | Rick James | CC BY-SA 3.0 |
more hints
|
| Mar 7, 2017 at 9:52 | comment | added | dlearious |
I've added the create statements and further detail on the server these queries are being run on. newsletter_subscription and degree_discipline are both in the users table. i'll give you suggestions ago now.
|
|
| Mar 7, 2017 at 1:14 | comment | added | a_vlad | and after create indexes (if not already) - direct go to "Also, try this ..." :) UNION work much faster than OR for different tables (self join as well). if it not resolve all problem - at least make it faster and more easy to profile each sub-query separate. | |
| Mar 7, 2017 at 0:53 | history | edited | Rick James | CC BY-SA 3.0 |
more
|
| Mar 7, 2017 at 0:48 | history | answered | Rick James | CC BY-SA 3.0 |