[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Krinkle krinklem...@gmail.com changed: What|Removed |Added CC|krinklem...@gmail.com |

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Bug 23682 depends on bug 1211, which changed state. Bug 1211 Summary: Subcategory paging is not separate from article or image paging https://bugzilla.wikimedia.org/show_bug.cgi?id=1211 What|Old Value |New

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Bug 23682 depends on bug 1211, which changed state. Bug 1211 Summary: Subcategory paging is not separate from article or image paging https://bugzilla.wikimedia.org/show_bug.cgi?id=1211 What|Old Value |New

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Bug 23682 depends on bug 1211, which changed state. Bug 1211 Summary: Subcategory paging is not separate from article or image paging https://bugzilla.wikimedia.org/show_bug.cgi?id=1211 What|Old Value |New

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Bug 23682 depends on bug 1211, which changed state. Bug 1211 Summary: Subcategory paging is not separate from article or image paging https://bugzilla.wikimedia.org/show_bug.cgi?id=1211 What|Old Value |New

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Aryeh Gregor simetrical+wikib...@gmail.com changed: What|Removed |Added Status|ASSIGNED|RESOLVED

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Bug 23682 depends on bug 1211, which changed state. Bug 1211 Summary: Subcategory paging is not separate from article or image paging https://bugzilla.wikimedia.org/show_bug.cgi?id=1211 What|Old Value |New

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Aryeh Gregor simetrical+wikib...@gmail.com changed: What|Removed |Added Status|NEW |ASSIGNED

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #15 from Tim Starling tstarl...@wikimedia.org 2010-06-01 09:09:50 UTC --- I've committed r67179 now, which comes closer to a complete workaround. I'll deploy it shortly. For a final fix, we should aim to have a carefully

[Bug 23682] CategoryTree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Tim Starling tstarl...@wikimedia.org changed: What|Removed |Added Summary|categorytree is inefficient |CategoryTree is

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #12 from Tim Starling tstarl...@wikimedia.org 2010-05-28 07:33:36 UTC --- (In reply to comment #9) I knew it!!! :-) zero rows is just one of cases, there are other expensive queries that return 10, 20, 30 rows - all with low

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Ilmari Karonen nos...@vyznev.net changed: What|Removed |Added CC||nos...@vyznev.net

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Stepro w...@stepro.de changed: What|Removed |Added CC||w...@stepro.de --- Comment #1

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Krinkle krinklem...@gmail.com changed: What|Removed |Added CC||krinklem...@gmail.com

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Aryeh Gregor simetrical+wikib...@gmail.com changed: What|Removed |Added CC|

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #4 from Domas Mituzas domas.mitu...@gmail.com 2010-05-27 14:47:27 UTC --- Stepro, small problems doing inefficient stuff means there are thousand projects doing inefficient stuff :( Aryeh, sure, we could just use automatic sort

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #5 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-05-27 15:35:50 UTC --- I also prefer sortkey hacks. Much easier to deploy. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Mormegil morme...@centrum.cz changed: What|Removed |Added Depends on||1211 -- Configure

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Tim Starling tstarl...@wikimedia.org changed: What|Removed |Added CC|

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 Daniel Mlot d...@rocketmail.com changed: What|Removed |Added CC||d...@rocketmail.com

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #8 from Tim Starling tstarl...@wikimedia.org 2010-05-28 02:18:31 UTC --- Proposed fix for the problem of expensive queries returning zero rows in r66987. -- Configure bugmail:

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #9 from Domas Mituzas domas.mitu...@gmail.com 2010-05-28 05:16:25 UTC --- I knew it!!! :-) zero rows is just one of cases, there are other expensive queries that return 10, 20, 30 rows - all with low selectivity. I have no idea

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #10 from Philippe Beaudette pbeaude...@wikimedia.org 2010-05-28 05:29:49 UTC --- I don't know the technical issues here, but from a user perspective, disabling this without notification when it's widely used across many wikis is

[Bug 23682] categorytree is inefficient

https://bugzilla.wikimedia.org/show_bug.cgi?id=23682 --- Comment #11 from Domas Mituzas domas.mitu...@gmail.com 2010-05-28 05:40:30 UTC --- Philippe, developers should've known that subcategory fetches are absolutely inefficient (and features like that have been disabled quite a few times,