On Tue, Feb 24, 2009 at 5:09 PM, Robert Ullmann rlullmann@gmail.com wrote: <snip>
I suggest the history be partitioned into "blocks" by *revision ID*
Like this: revision IDs (0)-999,999 go in "block 0", 1M to 2M-1 in "block 1", and so on. The English Wiktionary at the moment would have 7 blocks; the English Wikipedia would have 273.
<snip>
Though there are arguments in favor of this, I think they are outweighed by the fact that one would need to go through every block in order to reconstruct the history of even a single page. In my opinion partitioning on page id is a much better idea since it would keep each page's history in a single place.
-Robert Rohde