cfinley
May 20, 2021, 8:04pm
2
Not sure as to why the performance difference exists for your two scenarios, but i came into some inconsistency issues with general performance. Perhaps it could be of benefit.
This suggestion ultimately solved the problem of the long Query runtime.
BAQ with date range of 06/01/2020 - 06/30/2020. 25 records that represent all the days we shipped something. With 8 inline subquery calculated fields.
Run without any company criteria. Non Cross Company BAQ
13.683 minutes
Run with company hardcoded company = ‘abcdef’ on all tables marked with 1 including inline subqueries
3.45 minutes
Run with BAQ Special Constant of CurComp on all tables marked with a 1 including inl…