Hello,
At Monday 27 September 2010 22:12:05 DaB. wrote:
If we add copies of all indexes prefixed with
rev_deleted,
everything should be just as efficient in a view as you suggest, so I
don't see why we couldn't. In other cases there have been issues with
efficiency, but I don't see why those should exist here, offhand.
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).
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).
Sincerly,
DaB.
--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885