Sure, but when you say "insert", why run through a stored procedure? jOOQ has support for batch statements [1] and a data loading API [2]. Or you can write a single insert as well by adding several rows to the VALUES clause.
Now, you probably can't do that because you have some logic in your stored procedure. This is why I asked for the use-case. [1]: https://www.jooq.org/doc/latest/manual/sql-execution/batch-execution [2]: https://www.jooq.org/doc/latest/manual/sql-execution/importing 2017-11-09 16:26 GMT+01:00 <[email protected]>: > Thanks for your answer. The problem i'm trying to solve is that > application i have will, in some cases, have to insert 1000 rows at once. > Every 10 seconds. While using JDBC i discovered that calling "insert" 1000 > times separately (even though each insert takes about 1ms) is way slower > than jamming 1000 in-params into a single "insert" call. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
