How does the batchInsert actually work? I'm trying...

# exposed

[jeggy]

How does the batchInsert actually work? I'm trying to insert 50.000 rows at once, and it takes way to long.

[tapac]

It uses jdbc batching under the hood, so there is no magic.
The speed of insertion depends on a database, jdbc driver and a lot of different options (such as connection bandwidth and does anyone blocks table where you want to insert).

[jeggy]

Thanks, just what I needed to know 🙂