On Sun, Jun 2, 2019 at 11:30 PM Bryan Davis <bd...@wikimedia.org> wrote:
> One "fix" I could imagine for this would be for the Wiki Replicas to > also provide per-entity views of the comment table that only return > rows related to a single entity table. For example a > "comment_ipblocks" view could use a where clause specific to the > ipblocks entity table like "WHERE exists( select 1 from ipblocks where > ipb_reason_id = comment_id and ipb_deleted = 0)" and exclude the tests > for other entities (image, filearchive, revision, etc). > See also https://phabricator.wikimedia.org/T215445. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
