Jeremy Dunck wrote:
On 10/15/05, Brion Vibber brion-e+AXbWqSrlAAvxtiuMwx3w@public.gmane.org wrote:
Deleted revisions are removed from the revision table and copied to the archive table. The only record of deletion time is in the logging table, and that won't tell you which revision was deleted when.
So, deleted revs aren't included in dumps at all?
Deletes are relatively rare (sysop) occurrences, right?
Some numbers of the German Wikipedia during two weeks measured with Special:log and Special:Newpages:
delete: 7.561 newpages: 7.438 newusers: 5.460 upload: 3.6302 move: 2.049 revert: ~1.500[1] block: 721 protect: 365 rights: 6 recentchanges: > 150.000[2]
[1] estimate by number of edits containing "revert" in it's comment. [2] estimate based on the last WikiStat numbers
You may wonder why there are more deletes but new pages but the "newpages" log only contains pages that have not been deleted. In my private opinion English Wikipedia does not delete enough non-encyclopaedic articles (like the "List of films ordered by uses of the word fuck" that is TOP 23[3] of the most viewed articles by the way) but the number of deltes should be somewhat higher than in the German Wikipedia. So I guess that there are almost 1.000 deletes a day because so many people confound Wikipedia with a place where they can put any nonsense. Have a look at http://en.wikipedia.org/w/index.php?title=Special%3ALog&type=delete to get to know what I mean.
Greetings, Jakob
[3] http://www2.knams.wikimedia.org/logwood/logwood.php?site=en.wikipedia.org at August, 11th 2005