Timeline for Why is this MySQL query taking so long?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 26, 2020 at 21:58 | comment | added | Gnudiff | incidentally, are there indices made on the relevant fields? | |
| Jul 26, 2020 at 18:27 | comment | added | Strawberry | Incidentally, I don't really see that this is a dba question. This is a straight-up mysql question, and belongs in Stack Overflow | |
| Jul 25, 2020 at 15:00 | history | tweeted | twitter.com/StackDBAs/status/1287039940140900354 | ||
| Jul 25, 2020 at 10:57 | history | became hot network question | |||
| Jul 25, 2020 at 6:41 | answer | added | Rick James | timeline score: 6 | |
| Jul 25, 2020 at 3:43 | vote | accept | Chris | ||
| Jul 25, 2020 at 3:35 | answer | added | user212533 | timeline score: 33 | |
| Jul 25, 2020 at 3:18 | comment | added | Chris |
@bbaird, it completed almost instantaneously. You know something about date_add that I don't?
|
|
| Jul 25, 2020 at 3:02 | comment | added | user212533 |
What happens when you change the WHERE statement to just dataDate = '2020-04-16' AND ticker = 'AAPL'
|
|
| Jul 25, 2020 at 2:56 | history | asked | Chris | CC BY-SA 4.0 |