Performance Difference in SQL Insert

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
2 posts Page 1 of 1
Post Reply

saikiranm

Posts: 2
Joined: Wed Dec 07, 2016 8:56 am
Post by saikiranm » Wed Dec 21, 2016 6:39 am
Quote
Team,

What is the performance difference when I use rowset variable directly in the SQL Insert compared to SQL Insert using ForEach loop?

- Kiran
Top

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ
Post by Support_Rick » Tue Dec 27, 2016 11:30 am
Quote
In a batch setting, it should be negligible.

Keep in mind that you do have the "Batch Size" field for Inserts/Updates under the Advanced Tab. This significantly increases your speed.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Top
Post Reply
2 posts Page 1 of 1
Return to “Community Forum”