News for hackers. Stuff that matters.
Re:Use SQL subqueries to count distinct 50x faster by danielweber on Friday January 24, 2014 @08:42AM (#7114825)
Yeah, in theory the database is supposed to take care of things like this for you.

In practice, every time I've seen a slow DB query, I've always been able to get huge improvements on it, even though the DB in theory had all the knowledge necessary to realize that I don't care about the intermediate results.

There are no comments on this comment yet.