https://bugzilla.wikimedia.org/show_bug.cgi?id=1211
Roan Kattouw <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #42 from Roan Kattouw <[email protected]> 2008-12-21 00:06:06 UTC --- (In reply to comment #41) > And as for the proposal in bug 450, I see two issues. First of all, you'd > surely need one query per namespace on each category view, which could be a > couple dozen on a lot of wikis. That seems kind of excessive, if it's > avoidable. Second of all, the current structure of the category table > reflects > the pages/subcats/files breakdown. If counts are given separately for all > namespaces, you'd need to store all the counts in the category table. This > would either require an ALTER TABLE for every namespace added or removed (not > happening), or else breaking off a new categorycount table like (cc_cat, > cc_namespace, cc_count) to store the counts and deleting the cat_pages, > cat_subcats, cat_files from the category table. > If we throw the separate paging thing out the window citing performance concerns, we could page by (ns, sortkey), which should be feasible given the right index (especially since the range condition is now also the first field of the ORDER BY). Of course that would page the main namespace first, then Talk, then User, etc., but that's the price we'd have to pay for not liking burned database servers. Jump-ahead links to a certain namespace would still be possible as well. -- 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. You are the assignee for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
