On Sun, May 19, 2019 at 3:07 PM Pietro De Nicolao <power...@gmail.com> wrote: > Would it be possible to have a view like `revision_userindex` (which has > index on `rev_user_text`) with an index on the `rev_actor` column instead? > In this way, this very common join would be way faster.
Pietro, that is a useful suggestion, please file a ticket on phabricator or comment on Brooke's ticket: that is something that looks very reasonable to me (although it may had to be done in a different way for now, as far as I can see there is not yet a *real* actor column on the underlying revision table, neither on production nor in labs, and the join on the view may be making it slow). _______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
