GoAnywhere Forum

Posted: **Wed Dec 21, 2016 6:39 am**

Team,

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

- Kiran

Posted: **Tue Dec 27, 2016 11:30 am**

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.

GoAnywhere Forum

Performance Difference in SQL Insert

Performance Difference in SQL Insert

Re: Performance Difference in SQL Insert