Hi,

since some time we have RevisionDelete, which allows deleting specific revisions of a page without having to delete the whole page. This feature is currently enabled for Oversight on WMF wikis and the community wants it to be enabled for regular administrators[1].

The only bug currently blocking this request is https://bugzilla.wikimedia.org/show_bug.cgi?id=20186 which requests an easy method to filter history and contributions lists for RevisionDeleted edits.

I partially fixed that bug in r58153, but afaik there is a problem with the current database layout: To filter for revisiondeleted edits, one has to go through all history/contributions lists and look at each individual revision if it is rev_deleted or not. This clearly isn't efficient and fails for pages that have a large history.

Afaik, a database change is needed to make filtering for RevisionDeleted edits efficient for large pages (I'm no DB expert, though).

Any suggestions on this problem?

Regards,

Church of emacs

[1] https://bugzilla.wikimedia.org/show_bug.cgi?id=18780 https://bugzilla.wikimedia.org/show_bug.cgi?id=19697