That worked for me. For future reference, I ended up using the first
approach.
It wasn't a super scientific test, but my workload was 90 batches of 2000.
Keep in mind my test was doing a lot of application specific work too.
Composing an individual query strategy rows took about 150 seconds to
execute where as the batch/bind took 260 seconds.
Just as a baseline, I also no-oped those functions and found that that took
about 130s. So the approach added 130s instead of just 20s!
I didn't peek at the jOOq source to see what was happening so maybe this
was to be expected.
Thanks!
On Monday, June 24, 2019 at 12:46:11 AM UTC-7, Lukas Eder wrote:
>
> Hi Kevinjeet,
>
> In your second example, you cannot "bind" an expression to your batch. You
> can only bind values to it. You should make sure the expression is already
> in the INSERT statement.
>
> static class BulkInsertBufferV2 {
> public BatchBindStep insertBuffer = mysql.batch(
> insertInto(table("Table1"), field("BytesKey"), field("StringData"))
> .values(field("unhex({0})", String.class, null), null));
>
> public void add(Record record) {
> insertBuffer = insertBuffer.bind(record.getHexStringKey(),(String)
> record.getData());
> }
>
> public int[] flush(DSLContext mysql) {
> return insertBuffer.execute();
> }
> }
>
> Notice that those "null" values in the insertInto statement are
> "placeholders" for your bind variables. You have to put them there for
> syntactic reasons, even if that's a bit confusing. If you want to use an
> expression in your VALUES clause, you can do that, but you still have to
> place a bind variable placeholder somewhere.
>
> I hope this helps,
> Lukas
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/df385659-919d-4a86-b498-75f26a327863%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
