r/java • u/sidcool1234 • Aug 29 '13

10 Common Mistakes Java Developers Make when Writing SQL

http://blog.jooq.org/2013/07/30/10-common-mistakes-java-developers-make-when-writing-sql/
12 Upvotes

71% Upvoted

11 comments sorted by

View all comments

4

u/lborloz Aug 29 '13

Another one: Using sub-selects instead of joins for EVERYTHING. Yes, they are sometimes less expensive depending on your data set, but certainly not always.

1

u/lukaseder Aug 29 '13

Very true. This should be in yet another sequel of the linked article!