jdbcTemplate versus connection statement?

[obtuse finch]

What are the differences? In dealing with large amounts of data, which is best?

[tall garnet]

<@&1004656351647117403> please have a look, thanks.

[tall garnet]

While you are waiting for getting help, here are some tips to improve your experience:

Code is much easier to read if posted with syntax highlighting and proper formatting.

If nobody is calling back, that usually means that your question was not well asked and hence nobody feels confident enough answering. Try to use your time to elaborate, provide details, context, more code, examples and maybe some screenshots. With enough info, someone knows the answer for sure.

Don't forget to close your thread using the command </help-thread close:1027500463647621170> when your question has been answered, thanks.

[sly spade]

Run some benchmarks and see for yourself which is better for you imo

With loads of records it's going to inevitably take ages anyway

[analog willow]

well

everything is built on the base jdbc api

so my first guess is - try (var conn = ds.getConnection()) is always gonna win

[obtuse finch]

Yeah it seems like just jdbc with a connection is faster for me. Just trying to figure out how to efficiently update tons of records 😅