# Baq timeout for some users **URL:** \ **Category:** Epicor ERP 10\ **Tags:** baq, dashboard, e10, epicor\ **Created:** [August 12, 2023, 12:19am UTC](https://www.epiusers.help/t/baq-timeout-for-some-users/106011 "2023-08-12T00:19:50Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\ **Post date:** [August 14, 2023, 1:22pm UTC](https://www.epiusers.help/t/baq-timeout-for-some-users/106011/8 "2023-08-14T13:22:25Z")
> [@jdlester](#): > > What are the cons to using this? You are asking SQL server to generate a new execution plan every time the query is run this is “pricey” though in the grand scheme of things it is a lot less pricey than using a bad cached plan. There are quite a few entries in the forum about how all this works if you are curious do a bit of searching on Parameter Sniffing (I think we covered this in one of our podcast episodes) Here’s a few > [@BAQ 100x slower in Production than Dev/test (Vote for this Idea for an easier fix in the future)](https://www.epiusers.help/t/baq-100x-slower-in-production-than-dev-test-vote-for-this-idea-for-an-easier-fix-in-the-future/88340/2): > > So your statistics may be out of date @JasonMcD I would suggest you run a quick statiscs update on all tables involved in this BAQ in Production and see what happens. 9/10 times it flies right after. I’m not sure how you are doing maintainence on your DB but statistics are as important if not more than indexes sometimes. Try this (this takes a few seconds to run even on the largest of tables and it shouldn’t hurt much maybe a small performance hit for a little while but perfectly fine in my ey… > [@Series 1 EpiSode 4: Catch Up Call with Bart Elia](https://www.epiusers.help/t/series-1-episode-4-catch-up-call-with-bart-elia/93932): > > In this EpiSode:@bderuvo takes a much needed vacation roll_eyes and @josecgomez miscounts our episodes (its 4 not 5 neutral_face) then, he discusses a rumor going around that Epicor is going to force everyone to go to the cloud by 2024…(Spoiler Alert) They aren’t! We talk briefly about what parameter sniffing is and what negative and positive consequences it can have on our BAQs. Then we dive into a thoroughly enjoyable conversation with @Bart_Elia former Lead Software Architect at Epicor,… --- _[View the full topic](https://www.epiusers.help/t/baq-timeout-for-some-users/106011)._