I have a requirement for inserting some 70000 records (6 to 10 fields) into MS SQL server tables. As you know I have the option of batch insert for this, I would like to know the below from some of you who already used this batch JDBC jobs for huge volumes of data.
- Did you notice any optimum no.of records for a batch insert job to have good performace.
- Did you face any specific performance issues or bottlenecks in the process?
Thanks & Cheers:)