[Bug 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 --- Comment #27 from Aaron Adrignola aaron.adrign...@gmail.com 2010-05-04 15:35:09 UTC --- (In reply to comment #26) Is this feature currently avalilable for Wikimedia projects like pt.wikibooks? Helder It is currently live at en.wikibooks. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 --- Comment #28 from Helder heldergeov...@gmail.com 2010-05-04 13:14:40 BRT --- Cool! Now it is working at pt.wb too... (although it the parameter was already in some lists, it was necessary to add order = ascending before it works o.o) Helder -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 Chad H. innocentkil...@gmail.com changed: What|Removed |Added CC||innocentkil...@gmail.com Status|REOPENED|RESOLVED Resolution||FIXED --- Comment #25 from Chad H. innocentkil...@gmail.com 2010-01-07 19:47:24 UTC --- Marking this FIXED as of r60800. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 Martin Kraus martin_kraus_germ...@yahoo.com changed: What|Removed |Added CC||martin_kraus_germ...@yahoo.c ||om --- Comment #18 from Martin Kraus martin_kraus_germ...@yahoo.com 2009-01-21 16:50:19 UTC --- Ramac, if I understood comments #11 and #14 by Aryeh Gregor correctly, he is asking you to run the code with and without the change (i.e. with the current sorting by date and with the new sorting by name) on realistic data and report the performance. I would assume 1000 items would be more than enough for such a test. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 --- Comment #19 from Aryeh Gregor simetrical+wikib...@gmail.com 2009-01-21 17:31:23 UTC --- EXPLAINs on enwikinews_p from toolserver: mysql EXPLAIN SELECT page_namespace, page_title, c1.cl_timestamp FROM `page` INNER JOIN `categorylinks` AS c1 ON page_id = c1.cl_from AND c1.cl_to='Test' WHERE 1=1 AND page_is_redirect = 0 ORDER BY c1.cl_timestamp DESC; ++-+---++-+--+-+--+--+--+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---++-+--+-+--+--+--+ | 1 | SIMPLE | categorylinks | ref| cl_from,cl_timestamp,cl_sortkey | cl_timestamp | 257 | const|1 | Using where; Using index | | 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | enwikinews.categorylinks.cl_from |1 | Using where | ++-+---++-+--+-+--+--+--+ 2 rows in set (0.03 sec) mysql EXPLAIN SELECT page_namespace, page_title, c1.cl_timestamp FROM `page` INNER JOIN `categorylinks` AS c1 ON page_id = c1.cl_from AND c1.cl_to='Test' WHERE 1=1 AND page_is_redirect = 0 ORDER BY page_touched DESC; ++-+---++-+--+-+--+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---++-+--+-+--+--+---+ | 1 | SIMPLE | categorylinks | ref| cl_from,cl_timestamp,cl_sortkey | cl_timestamp | 257 | const|1 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | enwikinews.categorylinks.cl_from |1 | Using where | ++-+---++-+--+-+--+--+---+ 2 rows in set (0.00 sec) mysql EXPLAIN SELECT page_namespace, page_title, c1.cl_timestamp FROM `page` INNER JOIN `categorylinks` AS c1 ON page_id = c1.cl_from AND c1.cl_to='Test' WHERE 1=1 AND page_is_redirect = 0 ORDER BY page_title DESC; ++-+---++-+--+-+--+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---++-+--+-+--+--+---+ | 1 | SIMPLE | categorylinks | ref| cl_from,cl_timestamp,cl_sortkey | cl_timestamp | 257 | const|1 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | enwikinews.categorylinks.cl_from |1 | Using where | ++-+---++-+--+-+--+--+---+ 2 rows in set (0.00 sec) If the middle query is actually being run, the last one shouldn't be any worse, I suppose. But it still looks bad. I'm very reluctant to commit this, especially since I've never used the extension and am not familiar with its code. Sorry. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list
[Bug 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 --- Comment #22 from Ramac raffaele...@tiscali.it 2009-01-21 19:20:57 UTC --- @Martin: yes, DPL is used for dynamically generated bookshelves; we would like to use this feature also on it.wikibooks. @Aryeh: is there any way to fix it? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 Ramac raffaele...@tiscali.it changed: What|Removed |Added Attachment #5229|the diff patch |Diff patch for alphabetical description||order in DPL Attachment #5229 is|0 |1 obsolete|| -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 14971] alphabetical order method for DynamicPageList
https://bugzilla.wikimedia.org/show_bug.cgi?id=14971 --- Comment #17 from Ramac raffaele...@tiscali.it 2009-01-19 16:41:55 UTC --- Created an attachment (id=5703) -- (https://bugzilla.wikimedia.org/attachment.cgi?id=5703) Patch for alphabetical order in DPL -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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