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.