On 8/17/07, Stephen Bain <stephen.bain(a)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.