I'm surprised that this wouldn't be fast. jOOQ calls through to JDBC to execute batch statements. The only problem that I can see is that the insert statements thus generated are not uniform, i.e. you didn't equally set all values in all records. If that's the case, you might end up with as many as 1000 distinct INSERT statements.
To find out what kinds of statements are generated, you can turn on logging on DEBUG level: http://www.jooq.org/doc/3.2/manual/sql-execution/logging/ To keep control over rendered SQL, you might be better off creating an actual batch statement. Examples here: http://www.jooq.org/doc/3.2/manual/sql-execution/batch-execution/ Hope this helps, Lukas 2013/10/24 <[email protected]> > What is the JOOQ way to insert, let's say 1000 records? > I used batchInsert with an ArrayList, and it took way too long. Any help? > > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
