Poor performance / page load times of /home

[sammcj]

Describe the bug

Loading /home (with the list of shows) takes between 5.2 and 8.5s.

I have been discussing and sharing database and log dumps with @p0psicles on this issue.

To Reproduce Steps to reproduce the behaviour:

1. Install medusa from source / git on a CentOS 7 host OS and Python 3.6.8 (latest stable python3 for CentOS 7)
2. Add between 250-350 shows to medusa
3. Load the home page
4. Notice that the page takes a long time to finish loading

It does not make any difference which browser you use on the client side but I've tried: Firefox 81 on a new i9 MBP, Chrome stable on the same machine, Safari on iOS 13 and 14 on an iPhone 11 Pro.

Note: I have also had a friend who is able to reproduce the poor performance - although not quite as bad, at around 2.5-3s - running the latest Medusa Docker image and on a wired network with both Firefox and Chrome.

Expected behaviour

The /home page should not take longer than 1-2 seconds at most to load.

Screenshots

• Shared with @p0psicles

Medusa (please complete the following information):

• OS: CentOS 7, Kernel-ML 5.8.7-1
• Branch: Master
• Commit: b352bb6924afcdfafce176a540d53ce405ca1312
• Python version: 3.6.8
• Database version: 10

Debug logs (at least 50 lines): General > Advanced Settings > Enable debug

• Provided to @p0psicles

Additional context

The more columns you unselect (as pictured below) the faster the page loads, for example with no columns ticked the page loads in just over 1s, but with all ticked it can take as long as 8.5s.

I've tried:

• Starting medusa with an empty / no main.db: It's faster but still around 2.5s with no shows in the database at all.
• Starting medusa with an empty config.ini, main.db, cache.db and failed.db: again - faster, but still around 2.5s.
• I've ensured that the server is not under any load and the I/O is near idle.
• The server is an i7-4770K, 32GB RAM, Intel NVMe PCIe 750 SSD for OS+apps.
• The network is wireless, but with excellent signal strength (near the router), high end unifi networking hardware and has a throughput of around 600-850MB/s.
• All other web apps on the server load much faster with no performance problems (sab, couch, nzbhydra, plex) although none of those are Python3.

[Rouzax]

Is this not planned?

[sammcj]

I gave up and moved to sonarr which is a lot faster in all regards.