https://bugzilla.wikimedia.org/show_bug.cgi?id=19640
Ilmari Karonen <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #11 from Ilmari Karonen <[email protected]> 2009-08-02 11:36:35 UTC --- Okay, this is just FUBAR. If we don't currently have an efficient way of getting the subcategories of a category, then one should be created. Unlike Domas, I'm no DB expert, but I'd suggest adding a cl_fromns (?) field to the categorylinks table and creating new indexes to use it. (Unfortunately, I don't think MySQL is smart enough to use those indexes for queries that don't involve the namespace, so we'd either have to keep some redundant indexes or use the UNION hack. Domas can probably say which one he thinks would be the lesser evil.) Or just use the sortkey hack that Domas originally suggested. -- 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
