Welcome to Lemmy vX.XX.X-rc.X - The Lemmy Upgrade Thread
(lemmy.sdf.org)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 26 Jun 2023
106 points (100.0% liked)
sdfpubnix
1328 readers
11 users here now
Fans of SDF
founded 1 year ago
MODERATORS
I'm keeping an eye on this PR
Once that one's merged it should massively improve database performance under load. Instead of doing tons of full table reads with joins to the communities table, it'll be doing much smaller, faster reads. Currently those full reads happen for every up/down vote.
Converting those blind full-table scans with joins into smaller targeted reads is gonna be a performance gamechanger
Edit: it was just merged!