Timeline for Slow query with multiple group by
Current License: CC BY-SA 4.0
24 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 31, 2023 at 3:56 | answer | added | Tomas.Nemec | timeline score: 1 | |
| Mar 31, 2023 at 0:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 26, 2022 at 5:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 23, 2022 at 11:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 18, 2022 at 3:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 9, 2021 at 21:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 12, 2021 at 4:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 10, 2021 at 12:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 29, 2020 at 14:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 20, 2020 at 19:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 18, 2020 at 20:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Dec 18, 2018 at 19:32 | answer | added | Rick James | timeline score: 0 | |
| Dec 18, 2018 at 12:45 | history | edited | Tom V | CC BY-SA 4.0 |
typo & generic tag
|
| Dec 18, 2018 at 12:23 | comment | added | Phoenixy | No, that's fine. Because even if there are 10 new comments to the same topic, it should be 1 notification only. Sorry if I wrote it wrong. | |
| Dec 18, 2018 at 12:18 | comment | added | ypercubeᵀᴹ |
In that case, the final/external GROUP BY seems wrong. The query won't give you all comments but one result per topic.
|
|
| Dec 18, 2018 at 12:15 | history | edited | Phoenixy | CC BY-SA 4.0 |
added more details
|
| Dec 18, 2018 at 12:10 | comment | added | Phoenixy | It gets all the comments from threads (topics, news, pcitures) where a given user has commented and not yet seen the comment. Updated above. | |
| Dec 18, 2018 at 12:09 | history | edited | Phoenixy | CC BY-SA 4.0 |
added 367 characters in body
|
| Dec 18, 2018 at 12:02 | comment | added | Akina | Show ALL (with all indices) table schema, not a part of it. | |
| Dec 18, 2018 at 12:00 | comment | added | ypercubeᵀᴹ | Both queries are a mess. What result are they suppoed to give? | |
| Dec 18, 2018 at 11:58 | history | edited | ypercubeᵀᴹ | CC BY-SA 4.0 |
added 30 characters in body
|
| Dec 18, 2018 at 11:55 | review | First posts | |||
| Dec 18, 2018 at 12:45 | |||||
| Dec 18, 2018 at 11:54 | history | asked | Phoenixy | CC BY-SA 4.0 |