Can only run a BAQ in 3 month chunks

[josecgomez]

Try this

Strange, Poor BAQ Performance?

I’ve noticed recently on my 10.2.600.5 instance some very odd and poor performance on BAQs with seemingly innocuous things. For example, take this query. [image] If I include the table restraint on Part.ShortChar01, the query times out and will not run. If I exclude it, the query runs in under 5 seconds. [image] I had a different query that timed out if I put date parameters on the InvoiceDate field. Running the query WIDE open in a dashboard to return 30K+ rows takes a couple seconds. B…