On 8/17/07, Stephen Bain stephen.bain@gmail.com wrote:
We do keep timestamp data in the categorylinks table, so it's possible to work out roughly when a page was added to a category. However, AFAIK this is not actually used anywhere.
Enwp used the category timestamps for some automated prod tool on toolserver a while back. I think they found the data lacking, since any blanking/revert cycle renewed it.
For us it will probably be okay.
Note that it would be good if some technical types can check this out to make sure it actually works.
We carry an index on cl_to,cl_timestamp and it appears your query will correctly use it.. I don't see anything obviously broken from that perspective. But thats about all I can offer because my mediawiki internal kungfu is weak.