2) In special_recentchanges.php, we select with
"WHERE
cur_timestamp>$mindate", but cur_timestamp is not indexed. This
means that mysql linearly searches through the whole cur database,
everytime somebody views RecentChanges.
Why not simply log change-events to a separate table, and display data
from that log depending on the user's filter? Changes older than, say, two
weeks could be discarded by a cronjob.
-- Daniel