https://bugzilla.wikimedia.org/show_bug.cgi?id=23682

           Summary: categorytree is inefficient
           Product: MediaWiki extensions
           Version: any
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: Normal
         Component: CategoryTree
        AssignedTo: [email protected]
        ReportedBy: [email protected]


categorytree forces scans of millions of rows (for large categories) to return
0 row datasets quite often. 

this has been discussed in the past a lot, I'll write it down yet again.

there're few fixes, one is by prefixing cl_sortkey with character not used in
category names and filtering by it - would need rewriting sortindex only for
subset of rows. 

another is creating separate columns, creating or replacing indexes, etc - in
categorylinks table

another is maintaining subcategories table per category

-- 
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to