Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
- Posts: 2
- Joined: Wed Dec 07, 2016 8:56 am
What is the performance difference when I use rowset variable directly in the SQL Insert compared to SQL Insert using ForEach loop?
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
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.
Lead Solutions Consultant
Return to “Community Forum”