I came across a case where a simple search in Supplier Schedule Line takes around 1 hour to return results.
We’ve investigated and narrowed down that the condition that gives the biggest performance hit is the between condition applied on ‘Created’ field.
However, further investigation showed that the supp_sched_line_tab had more than 40 million records. So, the performance hit is self-explanatory.
40 million is a way too big of a number to exist in a single table. My question is, is there a procedure to clean up older / completed Supplier Schedule Lines in apps 8? If there is, where can I find more information on that?
