https://bugzilla.wikimedia.org/show_bug.cgi?id=2415
--- Comment #16 from Riley Lynch <shunpi...@gmail.com> 2011-11-28 07:05:30 UTC --- With a querycache of 250,000 rows, including 50,000 lonelypages rows, a query with a large offset without the patch: select SQL_NO_CACHE qc_type, qc_namespace, qc_title, qc_value from querycache where qc_type = 'lonelypages' order by qc_value ASC limit 500 offset 35000; --> about 0.191 seconds The same offset with the patch: select SQL_NO_CACHE qc_type, qc_namespace, qc_title, qc_value from querycache where qc_type = 'lonelypages'"+ and qc_seq between 35001 and 35500 order by qc_value ASC; --> about 0.004 seconds -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l