On Thu, Jul 12, 2012, at 01:29 AM, Platonides wrote:
On 11/07/12 16:14, Russell Blau wrote:
I'm glad to know that the appearance was deceiving. Having data from rosemary now, I come up with an estimated completion date there of July 30, assuming that the rate at which updates are received from WMF does not change.
I thought it would be worse. How are you measuring the sha1-populated boundaries?
I do a series of queries in the form "SELECT rev_sha1 FROM revision WHERE rev_id = NNN", with the NNN's selected by a binary search algorithm, to find the lowest rev_id for which rev_sha1 is "".
Of course, this was preceded by some other queries to establish that there are, in fact, three consecutive blocks of unpopulated revisions, and that the upper boundaries of these blocks have not changed.