We have a large BAQ (not written by me) that has been run every month for the last 2 years. The BAQ typically runs in about 40 seconds. We recently tried to run the BAQ and discovered that it now takes 2 hours and 3min :frowning: I created a support ticket and the support person seems intent on r…

For Giggles can you try OPTIMIZE FOR UNKNOWN Instead of RECOMPILE @DaveOlender . If its a parameter sniffing issue this might solve it. If this and RECOMPILE didn’t help then its bad Stats and or Idex issues and for a shared cloud instance that’s gonne require Epicor to do something.

If the BAQ has parameters odds are it’s a case of Parameter Sniffing, and @Banderson 's suggestion should work like a charm.

Thank you @Banderson for the suggestion. I tried that execution setting - I do not think it is working. I ran a test for a range of One day and it took 12min - that is the same number was getting earlier. However, thank you again. DaveO

what is in query execution plan?

[image] DaveOlender: I tried that execution setting - I do not think it is working. It’s probably “working” it just may not change anything. Sometimes it helps, sometimes is doesn’t. Has it been run since the last upgrade?

Did you upgrade recently? We saw the same issue after the flex 2 cloud upgrade on 8/26. I had several BAQs and related dashboards doing the same thing. A query that would normally take 5 seconds would take 90. I had to increase the queryTimeOuts to get us going. They would run normally at certain pe…

RECOMPILE just throws away existing execution plan, which probably already was discarded after a month of not being used. It is just new plan is not as good as old. Maybe data changed, maybe statistics, or both.

Mr. Brandon: It has not been run since the last upgrade. Also, the Classic UI fails with a server timeout error? If i run the BAQ logged as “Browser ONlY” and run the BAQ as a Kinetic UI - then i do get records back - it just takes forever (or seems like it - i am not a patient person). I am curr…

Thank you @josecgomez and @Banderson - the OPTIMIZE FOR UNKNOWN and “UseAlternateCompanySecurity” combination did the trick. The full month now runs in 49Seconds. You guys are AWESOME. [image]

Well, now I’m curious, what’s “AlternateCompanySecurity”? I’ve never seen that before, and if the name is anything like it sounds… we could use that! lol.

Mr. Brandon: I am not really sure what it does. I run into this whenever a baq runs in Pilot but not in Live. Epicor Support suggested this as a fix many moons ago and i found that i can switch between it being on or off and it will help us get the BAQ to run. I suspect it has something to do wit…

BAQ Performance suddenly horrible

Off Topic

Olga (Olga Klimova) September 26, 2023, 7:14pm 19

or ORDER BY

Topic		Replies	Views
BAQ Timing out but in SQL runs in less than 1 second Epicor ERP 10 baq	6	1928	August 24, 2020
Baq timeout for some users Epicor ERP 10 e10 , epicor , baq , dashboard	8	1407	August 14, 2023
Strange, Poor BAQ Performance? Epicor ERP 10 baq	26	3627	August 4, 2021
BAQ 100x slower in Production than Dev/test (Vote for this Idea for an easier fix in the future) Epicor ERP 10 baq	27	4351	July 10, 2023
BAQ executes in 8 seconds in BAQ Entry, but never finishes with REST Call Epicor ERP 10 e10	12	756	April 5, 2024

BAQ Performance suddenly horrible

Related topics