Hello experts,

I had tested my applicaion with different batch_size values and for my case I found setting batch_size=50 was the most efficient in terms of time taken for batch inserts of 10 K records. My concern is would this scenario be the same for production environment ? Is batch_size=50 gives most efficient performance as compared to the other values for batch_size, for all cases regardless of underlying hardware and number of records to be inserted ?

Please put some light on this. Thanks in advance

Cheers