26 sats \ 9 replies \ @k00b 29 Sep 2023 \ on: Stacker Saloon
Hmm it appears my notifications got even slower after last night’s update. That extra filter for mutes must be slowing things down
Speaking of notifications: Sometimes my check box goes back to the default (unchecked) after a few days. I'm not sure if it's a bug or if it's just my phone.
reply
If you're on iOS, it's probably this issue that we're still tracking
reply
Are you on iOS? This happens to me to on iOS. We've been attempting to diagnose but nothing yet.
cc @ekzyis another one
reply
I'm using an Android phone.
reply
aha so not just iOS! thanks!
reply
Oh, interesting
reply
Ah, replied while I didn't see your reply yet haha
reply
Mutes table indexed properly? I haven’t looked at the code closely
reply
Yep compound index on the two fields filtered on.
I have A LOT of items relative to other folks so I'm probably pretty sensitive to these slow downs, but with the way the notification query is structured - every item driven query needs to do this mute anti join ... so one option is to just rewrite the notifications query to not need to do that but it's sensitive to changes because all columns need to match.
I'll take a look a the query analyzer. It might be choosing some obviously wrong query plan.
reply