News for hackers. Stuff that matters.
Re:Korma: Tasty SQL for Clojure by andrewcooke on Monday November 21, 2011 @04:08PM (#3262814)
do you have evidence that subselects are inefficient? (i don't know the answer myself - i would hope that a database can do pretty decent optimisation, but perhaps this is the db equivalent of "given a sufficiently good compiler...").
Re:Korma: Tasty SQL for Clojure by ibdknox on Monday November 21, 2011 @04:38PM (#3262924)
It depends very heavily on which RDBMS you use as to what ends up optimized. It's a relatively well trafficked subject, a simple google search turns up quite a few results, for example:

http://www.mysqldbahelp.com/2010/03/subselect-vs-join-perfor...

Disclaimer: I didn't validate his results ;)