Hello folks,
I had some questions about the order or pages and revisions in the dump. As I understand, the order is according to the respective IDs. But where do these IDs come from? Are they the keys of the corresponding table in the database? So then they are more or less in order of creation? If that's the case, why does the dump begin with pages with titles mostly beginning with "A"?
Thank you, Chrisil
On Fri, Jul 02, 2010 at 05:54:35PM -0600, Chrisil J. Arackaparambil wrote:
table in the database? So then they are more or less in order of creation? If that's the case, why does the dump begin with pages with titles mostly beginning with "A"?
As far as I can tell, the Mediawiki database was preloaded with an alphabetical list of articles from some previous system. You will find that there is some number of articles in roughly alphabetical order at the start, followed by arbitrarily ordered articles. The are some out-of-order articles in the first mostly-alphabetical section due to article renames (which does not change their unique id).
Greg Hewgill http://hewgill.com
xmldatadumps-l@lists.wikimedia.org