Anthere wrote:
Thanks for this. Important point to add would be that only 2 weeks logs are kept for wikipedia.
The length of time the data is kept in the recentchanges table is actually highly variable. It's nominally one week, though I think en: is currently set to 4 weeks. It depends what the database admins want it at for whatever purpose, balanced against how much space it takes up. The longer the more useful for our purposes, of course ;-)
- d.