[Bug 14971] alphabetical order method for DynamicPageList

2010-05-04 Thread bugzilla-daemon
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

2010-05-04 Thread bugzilla-daemon
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

2010-01-07 Thread bugzilla-daemon
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

2009-01-21 Thread bugzilla-daemon
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

2009-01-21 Thread bugzilla-daemon
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

2009-01-21 Thread bugzilla-daemon
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

2009-01-19 Thread bugzilla-daemon
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

2009-01-19 Thread bugzilla-daemon
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