On Mon, Sep 27, 2010 at 4:17 PM, DaB. WP@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.