https://bugzilla.wikimedia.org/show_bug.cgi?id=25931
--- Comment #10 from Tim Starling <[email protected]> 2011-04-07 03:11:35 UTC --- He means that because there is no "ORDER BY page_random", the query just fetches the first page from the category that satisfies the page_random condition. So for page_random >= 0.99, it will scan 100 pages on average, even if the category is 100k pages. Comment #4 shows that it uses the cl_timestamp index, so it's very likely to return a page from the first 10 or so pages that were added to the category. -- 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
