Closed
Bug 1071277
Opened 11 years ago
Closed 11 years ago
Remove DISTINCT from SELECT for performance optimization
Categories
(Webmaker Graveyard :: Events, defect)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: jon, Assigned: jon)
References
Details
(Whiteboard: [services] [oct31])
Attachments
(1 file)
In the count and data sql queries in the events controller we use distinct to filter out event IDs that are dupes because of duplicate tags, mentors, or coorganizers. It also requires that MySQL create a temporary table. It'd be good to remove this.
|
Assignee | |
Updated•11 years ago
|
Whiteboard: [oct3]
|
|
Assignee | |
Comment 1•11 years ago
|
||
Attachment #8500499 -
Flags: review?(cade)
|
|
||
Comment 2•11 years ago
|
||
* The [oct3] train has now left the station. So please update the whiteboard with [oct17], or whatever train you're now planning to put this on. Thanks!
|
|
||
Updated•11 years ago
|
Whiteboard: [oct3] → [services] [oct17]
|
|
||
Comment 3•11 years ago
|
||
* the [oct17] train has now left the station
* so please update with [oct31], [nov14], [nov28], etc.
|
||
Updated•11 years ago
|
Whiteboard: [services] [oct17] → [services] [oct31]
|
|
||
Comment 4•11 years ago
|
||
Filed bug 1085422
|
|
||
Updated•11 years ago
|
Attachment #8500499 -
Flags: review?(cade) → review+
|
||
Comment 5•11 years ago
|
||
Commit pushed to master at https://github.com/mozilla/webmaker-events-service
https://github.com/mozilla/webmaker-events-service/commit/543099cf7aec63d01317b4142b2be5fe789fae3e
Fix bug 1071277 - Remove DISTINCT clause
|
|
||
Updated•11 years ago
|
Status: ASSIGNED → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•