SQL Task Push vs Pull
Posted: Wed May 16, 2012 10:40 am
Hi, we have a procedure which use the sql tasks to PULLS records from a remote db (server B) and inserts them into the local db( server A, both are Iseries servers). This was pulling in 19 million records and was taking approx. two hours to complete.
Due to some process timing issues with the remote box, we changed the procedure from a pull to a push, so now when the processes complete on the remote server (server B) it then PUSHES the records to the local server (server A). When we made this change the process has slowed down considerable, it takes sevaral hours to process one tenth of the file (about 1.2 million records) before it would eventually timeout (about 4 hours).
My question is there any communication differences between pulling and pushing data using the SQL tasks? or do you have any ideas as why the transfer speed would change so dramatically?
Due to some process timing issues with the remote box, we changed the procedure from a pull to a push, so now when the processes complete on the remote server (server B) it then PUSHES the records to the local server (server A). When we made this change the process has slowed down considerable, it takes sevaral hours to process one tenth of the file (about 1.2 million records) before it would eventually timeout (about 4 hours).
My question is there any communication differences between pulling and pushing data using the SQL tasks? or do you have any ideas as why the transfer speed would change so dramatically?