ssolberg
VIP Member
Noticed a SAR 5610326 that is similar to what I am experiencing. We have always searched on both the Vendor # and the first Cat Code (PRP1). We recently added quite a few more part masters to our system but they (technically) should not have impacted this inquiry but obviously they did. We still have the same number of parts that fall into the Vendor # and Cat Code selection as before we loaded new part masters. But... if I make the same selections now, the inquiry takes "forever" (1+ hours) just to bring up a few dozen parts. If I only select on the Vendor #, parts pop right up but many more than I need to look at. As soon as I include PRP1 to the selection (which now should just be a "subset" of the parts that took merely a minute to display) it takes over an hour to display. It's killing us and wondering if anyone else has resolved this.
I looked at the code for P43011 and it clearly has to do with the logicals that are used for the various flavors of selections. Any of the other selections appears to go over a variety of logicals that are only over the F4102 file. If you choose to include a search over the category codes (PRP1, PRP2, or both) you run over a JOINED logical (F4102JO) of F4102/F41021, and also does not have the Vendor # in the key.
Programmer/Developer/Anything-They-Give-Me
World A7.3 c11
I looked at the code for P43011 and it clearly has to do with the logicals that are used for the various flavors of selections. Any of the other selections appears to go over a variety of logicals that are only over the F4102 file. If you choose to include a search over the category codes (PRP1, PRP2, or both) you run over a JOINED logical (F4102JO) of F4102/F41021, and also does not have the Vendor # in the key.
Programmer/Developer/Anything-They-Give-Me
World A7.3 c11