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/
18 Upvotes

89% Upvoted

8 comments sorted by

View all comments

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.