Some of our Epicor users experience extreme slow downs on loading a BAQ through a customization but when using a different user ID on the same computer, its fast!

[klincecum (Kevin Lincecum)]

@josecgomez

parameter sniffing issue.

I thought BAQ sql queries were recompiled each time?

If not, should he try the Option Recompile trick?

Edit: In case @josecgomez doesn’t get back to us, here is a relevant thread where he goes into it:

BAQ 100x slower in Production than Dev/test (Vote for this Idea for an easier fix in the future)

Same BAQ (one I made to compare BOMs) In Production (today): 127 seconds In Dev DB (refreshed a few weeks ago): 1.2 seconds Prod and Dev are on the same machine I even exported the (“slow”) Prod BAQ and imported it into Dev and it still runs faster (1.3 seconds) in Dev! It’s just this one that is doing this, and only today (so far).

For example...

Another BAQ (analyzes PartDtl) In Production: 47 seconds In Dev DB: 55 seconds Those are normal times; there are a lot of factors there, but poin…