BAQ TEST Performance

[cfinley (Chance Finley)]

Sometimes the mirroring of queries from BAQ to SQL can reveal how you should have built the BAQ. I’ve done this myself and realized how i built the BAQ was wrong/suboptimal.

Could you provide your recreated SQL query so I can see what you were trying to accomplish? Also have you tried seeing if deleting a specific table drastically increases performance? Perhaps you have a bad link that has slipped by. Its also worth mentioning the below link with some BAQ Engine issues that plague anything prior to 10.2.700 and below

Improving BAQ Performance

The BAQ performance inconsistencies with adding or not adding the “Company = CurrComp” criteria, have been resolved with work done in 10.2.700. Prior to that work, the BAQ engine would automatically use a Temp Table it populated with valid Company values for the query and the TT would be “joined” to the Company column. Depending on what other criteria was in play, that join could result in sub-optimal performance. The BAQ has to account for a number of different scenarios including Cross Compan…

RDD BAQ Report timeout

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…

P.S. I hope you are not still on 10.0 which is listed on your profile. I would not expect great results from that buggy version. Screenshot looks kinetic-ish though. So I think you are okay on that front