Mythbusters - SELECT DISTINCT vs GROUP BY (1 Viewer)

Frothingslosh

Premier Pale Stale Ale
Local time
Today, 17:53
Joined
Oct 17, 2012
Messages
3,276
Thanks, guys.

Colin, I went ahead and signed up and added the link in a reply to his comment.

EDIT: So just as an FYI, my tests were run in SQL Server, which means that that's the performance you can expect from a passthrough query. I'll see if I can't get some free time to run tests in Access running a front end query against a linked back end this week or next. It could be enlightening to see which way it goes.
 
Last edited:

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 16:53
Joined
Feb 28, 2001
Messages
27,001
ROFL

If you only knew how busy I've been lately, and how little of it has been working with Access. Got promoted a couple times, and my workload is WAAAY heavier now than it used to be.

Hey, Frothy! Congrats on the promotion. It is understood that when you get a promotion, people start expecting more from you. But hey, what is life without challenges? As long as the promotions carried extra cash in the deal, that's a good thing. (No, not asking about money, just commenting.)
 

Frothingslosh

Premier Pale Stale Ale
Local time
Today, 17:53
Joined
Oct 17, 2012
Messages
3,276
Thanks. And yeah, good performance is always rewarded with more, harder tasks.

And yeah, there was definitely more cash involved.
 
Last edited:

Users who are viewing this thread

Top Bottom