[Toolserver-l] Please respect the rev_deleted-field

[Aryeh Gregor]

On Mon, Sep 27, 2010 at 4:17 PM, DaB. <WP at daniel.baur4.info> wrote:
> I tried it today. It morphs a 1.36s query (simple count-query on my username
> on dewiki_p) into something I canceled after 2 minutes (I tried both: if-
> selecting and where-clause).

What exactly did you try?  You'd need to change indexes on the
underlying table for this to work acceptably.

> And I don't see the point to allow users to see the archives-table, but not
> the deleted revisions (the critical stuff is in the hidden-table anyway).

I'm not clear on why toolserver users are allowed to see deleted
revisions to begin with.  rev_deleted is supposed to supplant
oversight, and that includes things that nobody is really supposed to
see.  I particularly don't understand why we hide stuff from the
logging table but not the revision table.