JDE_SCHMITT
Member
I'm at a client who is having issues with slow searches on the "Next Status" field in the Sales Order Detail screen. Simply searching for a next status of 600 takes minutes. I've attached the JDEdebug.log for the "find" clik involved. The Client is running XE Update7 SP22_Q1 AS400 V5R1. The client is coexistent with World. Their were no indexes for OW on the f4211 or f42119, so using OMW I generated indexes for these files thinking it had to help...it did not. There is approx 10k records in the f4211 and 1.8m records in the f42119 files.
After creating indexes is there something I need to do to activate them? should I restart OW services maybe?
Thanks all.
Bill
After creating indexes is there something I need to do to activate them? should I restart OW services maybe?
Thanks all.
Bill