WCF icon indicating copy to clipboard operation
WCF copied to clipboard

confirmTime in wcf1_user_notification's (userID, eventID, objectID, confirmTime) INDEX appears to be useless

Open TimWolla opened this issue 3 years ago • 2 comments

I was unable to find a query that would be able to leverage the existence of the confirmTime as part of that index. All queries involving confirmTime do not involve objectID.


This is a follow-up for #4105.

TimWolla avatar Apr 07 '21 07:04 TimWolla

Moving this to 5.5. because the automated marking of notifications as read should be cleaned up first.

TimWolla avatar Apr 20 '21 09:04 TimWolla

All the queries for the marking of notifications as read should be cleaned up by now. Now there are several queries including a confirmTime = 0 and also an objectID.

Moving this to 5.6 to revisit whether the index should be modified or not, after the updated queries have been deployed into production.

TimWolla avatar Oct 11 '21 08:10 TimWolla