Team,
What is the performance difference when I use rowset variable directly in the SQL Insert compared to SQL Insert using ForEach loop?
- Kiran
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.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Performance Difference in SQL Insert
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.
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696