I’ve got to be doing something wrong here. I need to make a Ubaq on some UD fields in the JobMtl and the JobAsm tables. I’m working on some testing and anything that I do with the JobEntry UpdateExt takes at least 30 seconds per row. I removed anything related to the UD field and am just testing with JobHead.UserChar1 field. the JobEntry Ext BO seems to require jobmtl, jobasm, and JobHead tables. I only have one updateable field set up. I also disabled any BPM’s that have to do with anything Job. Still very slow.
Is there something else besides the JobEntry UpdateExt BO that I should be using? Do I need to tie some more fields together? Less? adding filters somewhere? Any help or ideas would be appreciated.
Correction, I timed it, and it takes over 2 mins.