DB Insert Query Optimisation
Below code i am giving 1000 batch size to insert query into Azure sql db its taking so much time 20 min to process 3 lakh data Is there any way to reduce the time ? also tried increasing batch size getting deadlock for 2000 batch count