5 ms·
I'd like to see the runtime for the same query but (1) without 'distinct', (2) without the date formatting and (3) with an inner join.
by lunchladydoris 8y ago
I'd like to see the runtime for the same query but (1) without 'distinct', (2) without the date formatting and (3) with an inner join.
- ckastner 8y agoMy thoughts exactly. The post references a StackExchange question [1] which has a simple analysis, and four helpful suggestions (similar to yours), as to which the author states: "I tried the first suggestion, but the results weren't promising. As experimenting with each suggestion could easily take at least half a day, I proceeded with a way I knew would work efficiently and reliably"
- schrodinger 8y ago1: https://dba.stackexchange.com/questions/213983/can-i-speed-up-a-large-mysql-mariadb-join-through-partitioning-or-merging https://dba.stackexchange.com/questions/213983/can-i-speed-u...
- deleted 8y ago[deleted]
- sgt 8y agoCorrect. When I see developers using 'distinct' and complaining about some query performance, it's almost always the developer doing it incorrectly rather than an issue with the database.