Hi Experts,
We are using ODBC connector to fetch the record from AS/400 table( through driver VMdb225.so) and insert into SQL Server again by using ODBC connector(through driver VMsqls25.so).
Its taking approximately 24 minutes to load 1.2 million records.
![Mad :x](./images/smilies/icon_mad.gif)
I have tried to change the record count value from 0 to 20000 and array size from 2000 to 200000 but still the average execution time is approximately 24 minutes for the same table.
I also ran the job in 2 nodes as well as on 4 nodes, but there is no significant change in performance( still it takes around 24 min).
![Shocked :shock:](./images/smilies/icon_eek.gif)
Is there any other parameter which we have to change inorder to increase the performance?
Appreciate all your help!!
Thanks in Advance!!