RoundSparrow@lemmy.mlM to Lemmy Server Performance@lemmy.ml · 1 year agopost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)message-squaremessage-square19fedilinkarrow-up14arrow-down10
arrow-up14arrow-down1message-squarepost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)RoundSparrow@lemmy.mlM to Lemmy Server Performance@lemmy.ml · 1 year agomessage-square19fedilink
minus-squareRoundSparrow@lemmy.mlOPMlinkfedilinkarrow-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