2 Replies Latest reply on Aug 1, 2017 2:05 AM by mistrz_7

    batch size

    mistrz_7

      Hello,

       

      I load huge csv file to db using Jberet. I think that jdbcItemWriter commits every 40 or 50 records. Is it possible to change batch/commit size? I would like to commit every 3000.

       

      Regards

      sw

        • 1. Re: batch size
          cfang

          The jdbc batch insert size is the same as the step item-count value.  jdbcItemWriter just add all items in a chunk to the prepared statement.  The underlying jdbc driver may impose some limits on the batch insert size and split it further up.

           

          In your app, is the step item-count consistent with the jdbc insert batch size?

          • 2. Re: batch size
            mistrz_7

            Thank. Now I understand how it works.