Diagnosing Complex BAQ Slowness Kinetic

[cpilinko (Christian Pilinko)]

BAQ Performance with Part Rev

So have a query that is checking the differences on PartMaterial between two companies. I two have subqueries that give a list for one company and one for the other that are join in the top level to give me the differences. As usual, running the phrase in SSMS is fast. I know Epicor doesn’t actually execute that query but I do somewhat expect that the difference in time to return should be minimal. I’m doing a Top 500 and SSMS executes in .01 where as the BAQ takes over 80 seconds. Digging int…