If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at
https://insiders.goanywhere.com.
If you need an immediate response, please create a support ticket or contact our support team by email at
[email protected].
-
saikiranm
- Posts: 2
- Joined: Wed Dec 07, 2016 8:56 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
-
Support_Rick
Support Specialist
- 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.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696