Comment on Welcome to Lemmy vX.XX.X-rc.X - The Lemmy Upgrade Thread
SDF@lemmy.sdf.org 3 years ago
Wow! UI: 0.18.1-rc.10 BE: 0.18.1-rc.9-1-gf0e487f18 is so much better. What a fun holiday weekend for everyone. Thank you for still being here!
Comment on Welcome to Lemmy vX.XX.X-rc.X - The Lemmy Upgrade Thread
SDF@lemmy.sdf.org 3 years ago
Wow! UI: 0.18.1-rc.10 BE: 0.18.1-rc.9-1-gf0e487f18 is so much better. What a fun holiday weekend for everyone. Thank you for still being here!
entropicdrift@lemmy.sdf.org 3 years ago
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!