WCF
WCF copied to clipboard
confirmTime in wcf1_user_notification's (userID, eventID, objectID, confirmTime) INDEX appears to be useless
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.
Moving this to 5.5. because the automated marking of notifications as read should be cleaned up first.
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.