DPIclimate / broker

3 stars 3 forks source link

Webapp and/or RESTAPI is too slow #59

Closed dajtxx closed 2 months ago

dajtxx commented 4 months ago

Fetching the physical device list seems took over a minute. The logical device list took 50 seconds.

When looking at the request to get physical devices, 10MB of HTML was returned and there were large amounts of empty lines in the current mapping table cell around the mapped device link.

The logical device list was 2.9MB and had the empty line problem.

The Wombats page only returned 57KB and didn't have the blank lines, but still took 37s.

Restarting the website and restapi containers did not help.

There were 3 old db backup processes still running. Killing those did not help.

The rest of the system seems to be running ok, watching the logs does not show any noticeable delay in processing messages.

dajtxx commented 4 months ago

A test instance with the core tables restored shows the same whitespace in the HTML, but is not noticeably slow.

Querying the physical_devices table via psql is not slow.

There were a few stuck pg_dump processes in the container. Killing them seems to have fixed the speed issue.

Still worth looking at why the HTML is filled with empty lines though.