Long-running version of UBE

[jgrams]

We have a custom Virtual Pull UBE with approximately 45 versions. Most versions run only a couple of minutes and a few run a little longer, with the longest one running 15 minutes. We just created a new version and we have the data selection narrowed down as much as possible, but this version runs over an hour. We are reading about 5000 records, but are only printing items with active data. Most of the items we're looking at in data selection don't have active data to print, but we need to process them in case they do. Our output is usually less than 10 records. It seems that this version of the UBE runs longer because it has less data to process. Has anyone experienced a similar problem or have suggestions on what we may do to reduce the runtime of this version?

Jennifer Grams
OneWorld ERP8, AS/400

 

[Zoltan_Gyimesi]

Hi Jennifer,

Would be a help for us to help you, if you share the selections of two UBE:
- less data, longer running
- more data, shorter running

I can suppose only one thing:
Based on the extra selection, which narrow down the data, drive SQL optimizer to make worse decision on execution plan.

Regards,

Zoltán