https://bugzilla.wikimedia.org/show_bug.cgi?id=25931
MZMcBride <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #12 from MZMcBride <[email protected]> 2011-04-07 03:32:32 UTC --- Hmm. Using the Toolserver's enwiki_p: mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.999 ORDER BY page_random ASC limit 1; +-----------------+----------------+ | page_title | page_namespace | +-----------------+----------------+ | Jan_van_Deinsen | 0 | +-----------------+----------------+ 1 row in set (0.34 sec) mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.999 ORDER BY page_random ASC limit 1; +-----------------+----------------+ | page_title | page_namespace | +-----------------+----------------+ | Jan_van_Deinsen | 0 | +-----------------+----------------+ 1 row in set (0.00 sec) mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.999 ORDER BY page_random ASC limit 1; +-----------------+----------------+ | page_title | page_namespace | +-----------------+----------------+ | Jan_van_Deinsen | 0 | +-----------------+----------------+ 1 row in set (0.00 sec) mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.989 ORDER BY page_random ASC limit 1; +---------------+----------------+ | page_title | page_namespace | +---------------+----------------+ | Pavol_Baláž | 0 | +---------------+----------------+ 1 row in set (0.19 sec) mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.19 ORDER BY page_random ASC limit 1; +---------------+----------------+ | page_title | page_namespace | +---------------+----------------+ | Anthony_Tupou | 0 | +---------------+----------------+ 1 row in set (29.98 sec) mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.28 ORDER BY page_random ASC limit 1; +--------------+----------------+ | page_title | page_namespace | +--------------+----------------+ | Chris_Lehane | 0 | +--------------+----------------+ 1 row in set (3.80 sec) mysql> select page_title, page_namespace FROM page JOIN categorylinks ON(page_id=cl_from) AND cl_to='Living_people' and page_random>=0.432901 ORDER BY page_random ASC limit 1; +-----------------+----------------+ | page_title | page_namespace | +-----------------+----------------+ | Civard_Sprockel | 0 | +-----------------+----------------+ 1 row in set (2.96 sec) This seems unacceptably slow. I think it'd be fairly trivial to disable this for categories with greater than X members until a better solution is implemented, however. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
