• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

R42800 Sales Update Data Selection and Job Performance

SL922

Active Member
We have R42800 no custom code for the version data selection: F4211.DOC <> 0, F4211.NXTR = 620, select 6 DCTOs with Equal To
ran for 35 mins processed 3923 records or 21 mins processed 2595 records
I would like to check to see if this is normal process time and the data selection is correct and efficient
I thought when data selection to select <> which will do a full table scan but I found standard JDE versions have the same data selection

Could you please compare with your R42800 to see if the performance is about right or if there is anything I can do to improve the job performance?
Thanks in advance to share your experience


E910, TR 9.1.5.10
 

HolderAndrew

Well Known Member
Hi,

there are many documents out there in Oracle that describe how performance can be improved in R42800 - running parallel versions, proc option selection are data selection techniques are the main methods to improve throughput as long as each version has unique data selection. For example try and balance selection of 3 versions each selecting on 2 DCTOs each.

Even though you are running standard i would still analyse debug logs and do this for a couple of orders both local and server side to just get a feel of where main time gaps are done (ie. in which BSFNs) as this might point you to the proc options that control them.

R42800 is an expensive process and does a lot of stuff so most companies will run as many versions as you need to get the volumes through within your required window.


Hope it helps

Andrew
 
Top