The page under Administration → System takes extremely long to load.
After waiting for 15 minutes the page is still loading.
I would like this page to respond in a reasonable timeframe (e.g. <5 sec)
After inspecting the page the API call that takes very long is: /api/system/info
We have it hosted in a VM with some complicated network rules, but I connected via remote desktop to directly request the url via hosts file to make sure that doesn’t interfere.
(from the outside the page gives an 502 bad gateway after a few min)
I would suggest regular database maintenance in that case (refreshing indices, refreshing statistics). What database provider (Microsoft SQL Server, Postgres, Oracle) are you using?
We are using Microsoft SQL Server as PaaS. We increased from 20 DTU to 200 DTU and this greatly reduced the time required albeit it’s still slow.
Initial request after startup: 2-3 minutes. Subsequent requests <30 seconds.
I will see if rebuilding indexes will significantly impact this load time.
Took a bit longer to get the correct permissions to our server.
Seems the usual DB maintenance scripts were not in place so, our indexes were severely fragmented and statistics were out of date. After updating them the system page is fast again(<1 sec).