[Toolserver-l] Please respect the rev_deleted-field

[Ilmari Karonen]

On 09/27/2010 11:17 PM, DaB. wrote:
> 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).

That's without any new indexes, I assume.

It seems to me that we may need those new indexes anyway, if we're going 
to have to sprinkle "and rev_deleted = 0" everywhere.  Then again, the 
queries that are most affected seem to be precisely such simple count 
queries that could be answered using the indexes alone, so if it's OK to 
included deleted rows in such counts, it might not be so important.

-- 
Ilmari Karonen