Change Batch Size for sql insert script
Answered
Is it possible to change the batch size of an sql script?
I have a large file of single row sql inserts. By default datagrip uses bulk inserts of 1000 rows. Is it possible to increase it even further?
Please sign in to leave a comment.
Hi Andreas, I would investigate the connection advanced properties for that.
BTW where did you find the batchsize of 1000?
regards Leon
Hi Leon,
if I run a large sql script with millions of single line sql commands it runs them in batches of thousand as displayed in the run window.
What do you mean with connection advanced properties?
Best Andreas
Hi Andreas, you can find the connection advanced properties under Data Source and then the tab Advanced
what is your database?
It's a postgres db.
So far I did not find a suitable advanced connection parameter for the bulk statement execution.
this is hardcoded and cannot be changed.
That's a bummer. :(