Am Mit, 2002-10-30 um 13.28 schrieb Brion VIBBER:
Those should be fixed. Any other problems?
There should be an INDEX on the rc_timestamp column.
I think we should adopt a principle similar to KeptPages for RC logs,
that is, to maintain a consistent log for 14 days or so, no matter how
many entries happen in those days, instead of just saying "the last 5000
changes". So I guess we should just DELETE FROM the RecentChanges table
all entries that are older than n days regularly.
Regards,
Erik
--
FOKUS - Fraunhofer Insitute for Open Communication Systems
Project BerliOS -
http://www.berlios.de