Page MenuHomePhabricator

Improve query for fetching user's subscriptions on a page
Closed, ResolvedPublic

Description

When displaying the topic subscription buttons, for each button, we need to check if the user is already subscribed, to display the button in the correct state.

Currently we do that inefficiently, with one database query per button. We can do it all in a single bigger query instead.

Event Timeline

Change 682191 had a related patch set uploaded (by Bartosz Dziewoński; author: Bartosz Dziewoński):

[mediawiki/extensions/DiscussionTools@master] Fetch user's topic subscriptions on the page in a single query

https://gerrit.wikimedia.org/r/682191

Change 682191 merged by jenkins-bot:

[mediawiki/extensions/DiscussionTools@master] Fetch user's topic subscriptions on the page in a single query

https://gerrit.wikimedia.org/r/682191