I’m calling a relatively simple BAQ via REST API and it’s taking consistently 3 seconds to return results. [image] The same query in the BAQ editor returns results much faster: [image] Any idea why this performance difference? I have noticed it with certain other simple queries as well, wherea…

Read this [image] Logging or debugging performance on REST BAQs (baqsvc) ERP 10 Is there an easy way to log or debug a performance issue with the BaqSvc for REST calls? I have a BAQ that takes around 100 ms to run in the Epicor…

Is tehre a lot of content? Maybe the parsing / serializing to JSON is consuming the time?

Not really, it’s only returning like 5-12 columns and only a few rows

Sounds like because it’s a baq, the model is not cached and has to be regenerated for each call, which is why it takes longer for REST rather than the designer, where it may be cached?

Upgrade to 10.2.200.14 or greater. This was addressed in that release

I’m on 10.2.200.3, so that would help to explain it :slight_smile:

NO, cache is not implemented yet, but probably BAQ part work faster in the latest release.

Sounds like I need to actually make the effort to upgrade then :slight_smile: Thanks Olga!

@Aaron_Moreng what tool is that in your first screenshot?

Hey jeff that’s a screenshot from postman

Ah ok. Have you tried executing the rest call locally in your environment and throwing a stopwatch on it?

REST BAQ call is quite slow?

Epicor ERP 10

Olga (Olga Klimova) October 24, 2018, 8:50pm 4

Read this

Topic		Replies	Views
Logging or debugging performance on REST BAQs (baqsvc) Epicor ERP 10	21	5045	March 13, 2020
BAQ executes in 8 seconds in BAQ Entry, but never finishes with REST Call Epicor ERP 10 e10	12	790	April 5, 2024
REST not returning same number of rows as BAQ - Anyone know why? Epicor ERP 10 e10	7	598	May 24, 2021
BAQ isues - query overhead processing, and concurrency issues Epicor ERP 10 e10 , baq	0	507	May 10, 2019
BAQ Timeout Epicor ERP 10 e10 , baq	11	6116	August 10, 2017

REST BAQ call is quite slow?

Related topics