UI extremely slow

[garanda21]

Describe the bug
From login, to navigate on web application, every click takes to many seconds. Maybe duplicate from issue #92, but he behaviour is exactly the same, loads up to 20 seconds.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'https://IP:8443'
2. Click on 'Login'
3. Navigate to the application menus
4. See slowness

Expected behavior
Faster load on ms. Actually is taking up to 18 seconds to load some pages

Environment (please complete the following information):

• OS: Docker
• Architecture: [e.g. arm64, amd64]
• Browser [safari]
• Version 0.2.0

Screenshots
Login screen:

Dashboard:

Logs

Console:

Additional context
I'm using docker with sqlite. Mapped config file and accessing trough mi local IP and HTTPS.

[alexjustesen]

@garanda21 can you log into your container's terminal and run php artisan optimize? This will refresh the application cache which can improve performance

[garanda21]

php artisan optimize

Done, result:

  INFO  Caching the framework bootstrap files.  

  config ................................................................................. 134ms DONE
  routes ................................................................................. 43ms DONE

But there's no much difference, here is the docker config that I'm using:

docker run -d --name speedtest-tracker \
    -p 8443:443 \
    -e PUID=1000 \ 
    -e PGID=1000 \
    -v /path/to/directory:/config \
    -v /path/to/directory/certs:/etc/ssl/web\
    ghcr.io/alexjustesen/speedtest-tracker:latest

Not strange commands or anything else on boot.

I'm trying to test with SSL_MODE=off or SSL_MODE=mixed, but is not possible to use only port 80, the application always redirect to https no matter what, adicional every time that I change SSL_MODE, the log shows this error: nginx: [emerg] a duplicate default server for 0.0.0.0:80 in /etc/nginx/site-opts.d/http.conf:1 and nothing works, I have to recreate the container.

[mztiq]

The UI is very slow for me too, when I click on the "results" tab it takes anything from 15 - 30 sec to load.
Already tried php artisan optimize, no noticable difference tho.

Here's my docker-compose.yml (changed volume mapping path and port):

version: '3.3'
services:
    speedtest-tracker:
        container_name: speedtest-tracker
        ports:
            - '<port>:443'
        environment:
            - PUID=1000
            - PGID=1000
        volumes:
            - '/path/to/config:/config'
        restart: unless-stopped
        image: 'ghcr.io/alexjustesen/speedtest-tracker:latest'

[alexdelprete]

can you describe the hw platform? rpi?

[mztiq]

No, it's an Intel NUC 7 i5 (BLKNUC7i5DNHE).
I run all my docker containers on this thing, speedtest-tracker is the only one being that slow.

[alexjustesen]

In the next release I'm going to add some additional debugging tools to see if we can narrow down what's causing the performance issues. Hold tight for a couple days.

[mztiq]

Hey there, just wanted to check back for those debugging tools you were talking about. Is any of that implemented yet? Still having major performance issues on the "results" tab, sometimes even running into timeouts especially when showing more than the default 10 lines per page.

[alexjustesen]

@mztiq and @garanda21 I forgot to ask, what kind of DB are you using?

[garanda21]

@mztiq and @garanda21 I forgot to ask, what kind of DB are you using?

My case is sqlite, mapped folder to "database.sqlite"

[mztiq]

@mztiq and @garanda21 I forgot to ask, what kind of DB are you using?

I'm using sqlite too.

[alexjustesen]

@mztiq and @garanda21 I forgot to ask, what kind of DB are you using?

I'm using sqlite too.

Both on rpi's too right? If so which ones

[garanda21]

Mine is dockerized on Synology NAS DSM7 DS218+

[mztiq]

@mztiq and @garanda21 I forgot to ask, what kind of DB are you using?

I'm using sqlite too.

Both on rpi's too right? If so which ones

No, it's an Intel NUC 7 i5 (BLKNUC7i5DNHE).
I run all my docker containers on this thing, speedtest-tracker is the only one being that slow.
see my comments above for more information like docker-compose.yml if needed.

[alexjustesen]

Would you guys be up for testing a different database instead of sqlite?

[mztiq]

Would you guys be up for testing a different database instead of sqlite?

Sorry for the late reply, of course I'm up for some testing, just deployed with MariaDB/MySQL.
Give me some time to report back, first I need to collect some speedtest results (since for me only the "Results" tab was slow when showing lots of results).