-----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)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE+3aHsxVlOmwh1xjgRAndLAJ0ZFP/tmSufIlj17ZJ+54G0iS5JcQCggZ19
W43mKGD12iMF8kIEV62mLlE=
=aky3
-----END PGP SIGNATURE-----