I have a data loading from DSO1 to DSO2.Where i also 4 field level routines to populate some fields using the master .Here my master is of 50,000 to 80,records.
It is taking more than 8 hours for loading 8 lac records.
Can any one guide me to in regard of performance.
Data packet size is 50,000 records/pack.
no sematice key is enabled .
I have read statements in fields routiens.No Loops ...