Slow BO method

My users have complained that opening the Serial Number Assignment form is very slow. I ran a trace and found out that the GetRows method from the PlantConfCtrl BO is taking around 20 seconds. This doesn’t make much sense as there’s only 3 plants in our system. Checking the database on table Erp.PlantConfCtrl shows the 3. Any thoughts?

@aidacra Anything else I can troubleshoot?

A similar question just popped up yesterday from a different customer so a new ticket with support will be welcome.

Question -
How many companies / sites / warehouses / partbins do you have?
Anything change in those lately?

1 Like

I’ll put a ticket in.

We have 3 companies, 3 sites (1 per), 27 warehouses, 70 bins. Really nothing extraordinary.

Ticket # is CS0000680510.

1 Like

Is attached to the other report and making is way thru triage. Much thanks

1 Like

I’ve just sent the trace logs.

I find the following server trace to be quite strange:
<Sql queries="22768" cacheHits="0" time="17645.5375" qryTypeCount="6" />

That’s an awful lot of queries for this.

cacheHits=“0”
cries

I have had conversations internally when the issue came in. I don’t know the status but keep after them to keep you updated :slight_smile: