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.