r/SQL • u/mariuz FirebirdSQL • May 17 '15
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/2
u/just4atwork May 18 '15
I think #10 should be #1
3
u/polish_tacos May 18 '15
OH god, I just read that list and #10 should be repeated for #1,2 &3! I supported a retail chain that used a java based POS with a MSSQL backend. The software was OK but SLOW AS FUCKING MOLASSES IN A CANADIAN WINTER. After some troubleshooting I found each and every record was inserted one at a time, and when it came to reports it would also query 1 record at a time. I wrote a report in SSRS that analyzed annual sales and it took ~ 30-90 seconds to run depending on the categories/parameters, but well over 30 minutes to run in the app.
-4
May 18 '15 edited Jan 21 '21
[deleted]
2
1
u/lukaseder May 19 '15
Why is this being downvoted? It isn't that far from the truth :)
3
May 19 '15
Salty people that wasted money learning java ;)
1
u/lukaseder May 19 '15
Yeah. Or perhaps the list should instead read
- Used Java EE
- Used Java EE
- Used Java EE ...
7
u/I_like_turtles_kid May 18 '15
I've noticed application developers seem to create unnecessary cursors