Tracking Down a Speed Issue

[klincecum (Kevin Lincecum)]

@NateS

What is setting option recompile?

Here is a link to a post with a screenshot, and also a relevant discussion thread.

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!

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: [optionrecompile]