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?

7 comments
Comment actions Permalink

Hi Andreas, I would investigate the connection advanced properties for that.

BTW where did you find the batchsize of 1000?

regards Leon

0
Comment actions Permalink

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

0
Comment actions Permalink

Hi Andreas, you can find the connection advanced properties under Data Source and then the tab Advanced

0
Comment actions Permalink

what is your database?

0
Comment actions Permalink

It's a postgres db.

 

So far I did not find a suitable advanced connection parameter for the bulk statement execution.

0
Comment actions Permalink

this is hardcoded and cannot be changed.

0
Comment actions Permalink

That's a bummer. :(

0

Please sign in to leave a comment.