this post was submitted on 26 Jun 2023
15 points (100.0% liked)
sdfpubnix
1320 readers
3 users here now
Fans of SDF
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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!