Mark Spritzler wrote:You can always test it out. Can you make a staging like server with the same settings talking to a temp database, and just try different intervals and see how it affect it.
Mustafa Garhi wrote:For one million records i just found difference of a few seconds between 1000 and 10,000.
We decided to stick to 10,000.
CommitInterval has done the trick.
Thanks everybody !!