'Batch size requirements for namedParameterJdbcTemplate batchUpdate method
I have a use case for synchronization where the no of updates can vary from 100's to 450K My concern was do I need to split batch to smaller sizes before I call batch update. Or will batch update be able to just take the complete list and determine optimal batch sizes internally.Or do I have to pre-split the batch into fixed sizes before I call batch update.
I do know that IN clause for JDBC has a limit of 1000. I have stumbled across that wanted to check if similar thing is case of batch update.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
