RoundSparrowM to Lemmy Server Performance · 1 year agopost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)message-squaremessage-square20fedilinkarrow-up14arrow-down10
arrow-up14arrow-down1message-squarepost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)RoundSparrowM to Lemmy Server Performance · 1 year agomessage-square20fedilink
minus-squareRoundSparrowOPMlinkfedilinkarrow-up1·1 year ago3 hours later… I put it into code and am experimenting with it. Some proof of concept results: https://github.com/LemmyNet/lemmy/files/12373819/auto_explain_list_post_community_0_18_4_dullbananas_with_inclusion_run0a.txt
3 hours later… I put it into code and am experimenting with it. Some proof of concept results: https://github.com/LemmyNet/lemmy/files/12373819/auto_explain_list_post_community_0_18_4_dullbananas_with_inclusion_run0a.txt