The problem is because the UpdateManySlim API endpoint is way faster in our test environment:
Vs. production:
I have the same form with the same code and the difference is huge. Also, both databases have similar data but are not identical
Anybody has clues as to what can cause this ?
Is your API datasource different between each environment? Is the ECM version the same between environments? Is there a difference between the RAM and the CPU in each ECM environment?
Since it is an internal API that is slower, I would look at the ECM server first and then the ECM client as the main areas that could be slowing down the internal API.
I would imagine that there are a lot more resource intensive applications and processes running on the production server compared to the test server, no? Competing resources calling the SQL database could be slowing this down. I also see different datalink queries and executions running in the production screenshot compared to the test one. Do you perhaps have the datalinks running using the client instead of the server? Is the ECM application installed on the same SQL server it runs off of for both environments?
As for the production server, you’re right that there is more stock on there. However, if I compare both dev and production ECM databases, they are pretty similar in term of quantity of rows.
For the number of calls, the Javascript is the same in both. The screenshots cropped the rest of the calls but they are there in DEV. The only call that is different in term of speed really is the UpdateManySlim
Not sure what you mean by ‘running using the client instead of the server’ ?
And the ECM application is installed on its own server and then they are connected to an external SQL server (Which is different for DEV / Production)
The only thing I’m noticing is that in my production, I see one more ‘Custom Field’ being sent and that one doesn’t seem to get all properties (There’s no CustomFieldGroupId for example). I looked at the form / content type and they seems identical
However, I tested another form and then they have the same number of custom fields (30) and the DEV took 1.1 second while the PROD took 14 second for that UpdateManySlim call. So probably not it
