11-10-2009 9:57 PM
Hi,
I am uploading the 3000 ISU data records through the EMIGALL transcation.
When i upload the device data records it takes only 3 mins.But if i upload the Connection object data records it takes 30 mins.
Can any one say what could be root cause of the problem for the connection object.
Thanks in advance.
Regards,
Santhosh
11-10-2009 10:06 PM
Santhosh:
Please read the sticky post and specifically the document for migration performance.
regards,
bill.
Edited by: William Eastman on Nov 10, 2009 11:06 PM
11-11-2009 10:31 AM
Santhosh,
I'd assume that most likely the root can be found in a badly performing database select. Please create an SQL trace (ST05) an analyse the execution times and execution plans of the red (=long running) SQL statements.
Kind regards,
Fritz