[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 Reedy s...@reedyboy.net changed: What|Removed |Added Attachment #6341|0 |1 is obsolete|| -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 Reedy s...@reedyboy.net changed: What|Removed |Added Keywords|patch | Status|REOPENED|RESOLVED Resolution||LATER --- Comment #22 from Reedy s...@reedyboy.net 2011-05-10 23:35:02 UTC --- RESOLVED LATER There's nothing actionable by the API at the moment If there does become something in future, feel free to reopen the bug at that point Do we have a tracking bug for that or something? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 --- Comment #18 from Bryan Tong Minh bryan.tongm...@gmail.com 2011-01-07 08:05:21 UTC --- The proper order by for the cl_sortkey index would be cl_to,cl_type,cl_sortkey -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 --- Comment #19 from Reedy s...@reedyboy.net 2011-01-07 18:21:37 UTC --- IF that is all that's required to fix it... It's worth adding an index (though, I've got a feeling adding the index might be quite slow especially on wmf et al. And is it still right post the sorting changes?), and backporting... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 --- Comment #20 from Roan Kattouw roan.katt...@gmail.com 2011-01-07 19:43:44 UTC --- (In reply to comment #19) IF that is all that's required to fix it... It's worth adding an index (though, I've got a feeling adding the index might be quite slow especially on wmf et al. And is it still right post the sorting changes?), and backporting... That's not the problem. The problem is that you have to join in the page table to filter by namespace, because the namespace isn't in the categorylinks table. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 Reedy s...@reedyboy.net changed: What|Removed |Added CC||s...@reedyboy.net --- Comment #17 from Reedy s...@reedyboy.net 2011-01-07 02:21:23 UTC --- mysql DESCRIBE SELECT /* ApiQueryCategoryMembers::run */ cl_from,cl_sortkey,page_namespace,page_title,page_id FROM `mw_page`,`mw_categorylinks` FORCE INDEX (cl_sortkey) WHERE (cl_from=page_id) AND cl_to = 'Oh_rly' ORDER BY cl_sortkey, cl_from LIMIT 11\G ++-+--++---++-+-+--+--+ | id | select_type | table| type | possible_keys | key| key_len | ref | rows | Extra | ++-+--++---++-+-+--+--+ | 1 | SIMPLE | mw_categorylinks | ref| cl_sortkey| cl_sortkey | 257 | const |2 | Using where; Using index; Using filesort | | 1 | SIMPLE | mw_page | eq_ref | PRIMARY | PRIMARY| 4 | wikidb.mw_categorylinks.cl_from |1 | | ++-+--++---++-+-+--+--+ 2 rows in set (0.00 sec) mysql Was wondering. Just removing the order by removes the filesort ;) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 duplicate...@googlemail.com changed: What|Removed |Added CC||alphos.og...@gmail.com --- Comment #16 from duplicate...@googlemail.com 2010-07-13 17:56:57 UTC --- *** Bug 24354 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
[Bug 19640] Categorymembers namespace filtering is inefficient, uses ugly hack in miser mode
https://bugzilla.wikimedia.org/show_bug.cgi?id=19640 Ilmari Karonen nos...@vyznev.net changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|FIXED | Summary|Categorymembers namespace |Categorymembers namespace |filter broken in miser mode |filtering is inefficient, ||uses ugly hack in miser mode --- Comment #15 from Ilmari Karonen nos...@vyznev.net 2009-08-24 23:41:43 UTC --- Anyway, I'm reopening this (with a slightly changed summary) because the temporary hack applied in r53304 really is ugly and inefficient and should be replaced by a better fix (e.g. adding new fields and indexes to the categorylinks table, or using the sortkey hack suggested by Domas). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- 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
