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
On Tue, 20 May 2003, Erik Moeller wrote:
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.
Now on test.wikipedia.org.
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.
Yes, that ought to help...
Thoughts?
I'm not sure of the real usefulness of this page; it's going to be dominated for a long time by the work of "conversion script". But it could be fun at least! :)
Also, I think it's high time we have a common function to handle validating the $limit and $offset parameters on the various specials.
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org