[Bug 26311] prop module is using pageids not titles for sorting
https://bugzilla.wikimedia.org/show_bug.cgi?id=26311 --- Comment #6 from Reedy 2010-12-13 23:11:25 UTC --- Looks to be the case http://forums.mysql.com/read.php?100,42780,42780 -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 26311] prop module is using pageids not titles for sorting
https://bugzilla.wikimedia.org/show_bug.cgi?id=26311 --- Comment #5 from Roan Kattouw 2010-12-13 22:25:15 UTC --- > Creating a view with a index of that rows, is not a better solution? Thanks. You can't create indexes on views, AFAIK -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 26311] prop module is using pageids not titles for sorting
https://bugzilla.wikimedia.org/show_bug.cgi?id=26311 --- Comment #4 from Umherirrender 2010-12-13 19:34:16 UTC --- (In reply to comment #1) > (In reply to comment #0) > > It is possible to change that > > order? > Not without melting the database :( Thanks for that informationen, that is not possible with the current database layout. Creating a view with a index of that rows, is not a better solution? Thanks. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 26311] prop module is using pageids not titles for sorting
https://bugzilla.wikimedia.org/show_bug.cgi?id=26311 --- Comment #3 from Roan Kattouw 2010-12-12 14:15:12 UTC --- (In reply to comment #2) > We are sorting on page_id, because that is an indexed field in the database. > It > could be possible to sort on (page_namespace, page_title) probably as that is > indexed as well. However I don't know what performance consequences that has. > Intuitively I would say that sorting on an int is faster than on a varchar. That's not it. In the case of prop=links, we're sorting by pl_from (which references page_id), then pl_namespace then pl_title. To accomplish the behavior the reporter is asking for, we'd have to sort by (page_namespace, page_title, pl_namespace, pl_title), and sorting on fields spread across multiple tables isn't indexed. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 26311] prop module is using pageids not titles for sorting
https://bugzilla.wikimedia.org/show_bug.cgi?id=26311 --- Comment #2 from Bryan Tong Minh 2010-12-12 13:53:36 UTC --- We are sorting on page_id, because that is an indexed field in the database. It could be possible to sort on (page_namespace, page_title) probably as that is indexed as well. However I don't know what performance consequences that has. Intuitively I would say that sorting on an int is faster than on a varchar. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 26311] prop module is using pageids not titles for sorting
https://bugzilla.wikimedia.org/show_bug.cgi?id=26311 Roan Kattouw changed: What|Removed |Added Status|NEW |RESOLVED CC||roan.katt...@gmail.com Resolution||WONTFIX --- Comment #1 from Roan Kattouw 2010-12-12 13:52:33 UTC --- (In reply to comment #0) > In my opinion is that not a intuitive order. I agree. > It is possible to change that > order? Not without melting the database :( -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l