On Sun, May 19, 2019 at 3:07 PM Pietro De Nicolao powerpdn@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).