In CVS:
A list of all pages, ascending by date. This should give all those who
crave for more copyediting a new addiction, as old pages are frequently in
need of work.
Implementation is a simple query on CUR. I am not sure about the index
use. EXPLAIN tells me the following:
EXPLAIN SELECT cur_title, cur_user, cur_user_text, cur_comment,
cur_timestamp
FROM cur
WHERE cur_namespace = 0 AND cur_is_redirect = 0
ORDER BY cur_timestamp
LIMIT 0 , 50
-->
table:cur
type:ref
possible_keys:cur_namespace,name_title_timestamp
key:name_title_timestamp
rows:14810 (German DB)
Extra:Using where; Using filesort
It seems reasonably fast, but the "Using filesort" still bugs me. To get
rid of that, I think we would have to create a combined namespace/redir/
timestamp index. Thoughts?
Regards,
Erik