pull down to refresh

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