Hi, I tried to update one of my tools (intersect-contribs) to use the `actor` table instead of the `revision.rev_user_text` field.
Joining the `revision` and `actor` tables on `revision.rev_actor = actor.actor_id` is painfully slow and makes my tool unusable. I guess that the reason is that there is no index on the `revision.rev_actor` column (which is nullable, by the way). 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. Best, --- Pietro De Nicolao > Il giorno 18 mag 2019, alle ore 00:27, Brooke Storm <bst...@wikimedia.org> ha > scritto: > > Similar to the earlier removal of text fields from the wiki replicas for > comment storage refactors in Mediawiki, we are going to remove “user text” > columns from the views that are deprecated in the Mediawiki schema to prepare > for when they will actually be removed upstream. The column drops are > tracked and explained here https://phabricator.wikimedia.org/T223406 > <https://phabricator.wikimedia.org/T223406>. The tables with names such as > <tablename>_compat will not see a difference in structure. The change is > scheduled for Monday, May 27th. > > The fields that are dropping from the views are: > revision: rev_user and rev_user_text. > archive: ar_user and ar_user_text. > ipblocks: ipb_by and ipb_by_text. > image: img_user and img_user_text. > oldimage: oi_user and oi_user_text. > filearchive: fa_user and fa_user_text. > recentchanges: rc_user and rc_user_text. > logging: log_user and log_user_text. > Ideally, tools that connect to the replicas should gather the information > from the appropriate entries in the actor table instead, again, this is > similar to the change for the comment table. The data is already there for > you to start using. The alternative is to try using the related > <tablename>_compat table, which won’t be changing in a user-visible way at > this time. > > > Brooke Storm > Operations Engineer > Wikimedia Cloud Services > bst...@wikimedia.org <mailto:bst...@wikimedia.org> > IRC: bstorm_ > > _______________________________________________ > Wikimedia Cloud Services announce mailing list > cloud-annou...@lists.wikimedia.org (formerly > labs-annou...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud-announce
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
