News for hackers. Stuff that matters.
Re:Use SQL subqueries to count distinct 50x faster by hglaser on Friday January 24, 2014 @12:23PM (#7116063)
OP here. Great points -- especially around MySQL and subqueries, which has been a frustration for us.

Comparing across different RDBMS's is a great idea. Maybe we can squeeze it into a future blog post. :)

Re:Use SQL subqueries to count distinct 50x faster by taspeotis on Saturday January 25, 2014 @12:34AM (#7119978)
I tried to do a fair job in recreating your queries and techniques with MSSQL. Turns out MSSQL picks the best plan from the start [1].

[1] https://news.ycombinator.com/item?id=7119976 or http://ta.speot.is/2014/01/25/use-subqueries-to-count-distin...