search

HDInnovations / UNIT3D-Community-Edition

Private Torrent Tracker Built With Laravel, Livewire and AlpineJS.
GNU Affero General Public License v3.0
1.99k stars 379 forks source link

(Add) Client torrent size sum to profile page #4169

Open Roardom opened 1 month ago

Roardom commented 1 month ago

This query's execution time is increased from 10 ms to ~550 ms for power users with a few thousand torrents, or ~30 ms for average users with a few dozen torrents. Is the increased page load time worth its usefulness?

Roardom commented 1 month ago

Can we test this temporarily in an environment with a tuned database and see how fast the queries load? I've got a feeling there's more to the story than my numbers tell. Considering the usefulness of this PR, I'd like to double check.

HDVinnie commented 2 weeks ago

Can we test this temporarily in an environment with a tuned database and see how fast the queries load? I've got a feeling there's more to the story than my numbers tell. Considering the usefulness of this PR, I'd like to double check.

Will test in a tuned production environment this weekend and report back.