-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Je Merkredo 04 Junio 2003 00:06, Tim Starling skribis:
Unless you've already fixed it, the English cur_random column is still fine.
SELECT cur_random FROM cur WHERE cur_random>0.01 ORDER BY cur_random LIMIT 10
Nope, it got broke again. Try restricting the query to the pages Special:Randompage is concerned with:
SELECT cur_random FROM cur WHERE cur_random>0.01 and cur_namespace=0 and cur_is_redirect=0 ORDER BY cur_random LIMIT 10
Not only did it take two minutes to return (mmm, partial table scans), but there are *huge* gaps: 0.010371912280444 0.0106440456683226 0.0130615625652127 0.0138753941411855 0.0403562412041763 0.0404494861517562 0.044624416199163 0.0523233311738105 0.0542095322666779 0.0586327482560954
When I checked this afternoon, there were only 82 article-space non-redirect pages with cur_random values less than 0.22something. 82 out of a hundred some thousand... so, no wonder that the page with the particular value was coming up repeatedly in my Random page clicks.
I'm regenerating the index again now...
- -- brion vibber (brion @ pobox.com)