Slow website UI load times

[jLynx]

Mainsail Version:

v2.5.1 (Edit: Just updated to v2.6.0 and still have the same issue)

Browser:

Chrome

Device:

Desktop PC

Operating System:

Windows

What happened?

When I load the webpage it takes around 8-20 seconds to load. (Validated on multiple high-end devices).

What did you expect to happen instead?

The page to load a lot faster than it currently does

How to reproduce this bug?

If you have a lot of history file, you will see this slow down. I just with a lot of use time (438hours)

Additional information:

hso the issue seems to be that it loads the entire history on page I it. My suggestion is to have it load the top X from history (maybe 10?) and the rest of the history can be loaded on the history page load

Screen_Recording_20230717_124612_Chrome.mp4

20230717_194902.mp4

You can find my DB here:
data.zip

[zellneralex]

See also https://discord.com/channels/758059413700345988/1130299768661344288

[jLynx]

After resetting my DB it still took ages to load.
After restoring the DB and then removing all my /home/pi/printer_data/gcodes files the page now loads contently in 3 seconds which is much better.

So that tells me that is still forcefully loading all the data in the gcodes folder on load. Note: All the gcode files have preview images with/in them from the slicer

My gcodes folder is 2.6G of data

[jLynx]

My OS is 64 Bit