Changes between Initial Version and Version 1 of Ticket #17582, comment 30
- Timestamp:
- 06/07/2011 08:06:33 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #17582, comment 30
initial v1 11 11 }}} 12 12 13 That way they'll only need to be ordered once, and the extra ID sub-ordering will strip out the dups . Best I'm aware MySQL won't do this automatically when using distinct, though I may be wrong (in which case it would certainly explain why it was faster to use distinct).13 That way they'll only need to be ordered once, and the extra ID sub-ordering will strip out the dups (at a negligible cost). Best I'm aware MySQL won't do this automatically when using distinct, though I may be wrong (in which case it would certainly explain why it was faster to use distinct).