[Bug 18770] listing of none protected page with list=allpages
https://bugzilla.wikimedia.org/show_bug.cgi?id=18770 --- Comment #5 from Reedy 2010-01-11 14:28:33 UTC --- [14:18:32] Reedy: Short summary: given that the existing appr* queries are apparently OK, this one should not be a problem -- 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 18770] listing of none protected page with list=allpages
https://bugzilla.wikimedia.org/show_bug.cgi?id=18770 --- Comment #4 from Reedy 2010-01-11 14:15:12 UTC --- [13:35:33] domas: Are queries like these OK to run on the cluster? http://pastebin.com/m72223c4b [13:35:43] EXPLAIN says "using where" but I think it's lying [13:36:29] depends [13:36:35] Also the row count is huge but I don't believe it'll really examine that much rows for a query with WHERE foo=const ORDER BY bar LIMIT 51 when there's an index on (foo,bar) [13:36:42] *many [13:36:48] if all pages have restrictions, this gets really expensive [13:36:49] :) [13:36:53] heh [13:37:01] Yeah it was kinda based on the assumption that protected pages are scarce [13:37:29] Of course the "get pages with protection X" variant (which already runs on the cluster) joins the tables in reverse order [13:37:56] ... hopefully [13:37:59] RoanKattouw checks [13:41:15] Hm the "get pages with protection X" query does indeed join page_restrictions first at the cost of filesorting, but I guess that's the lesser of two evils unless I totally rewrite this module to page by page ID -- 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 18770] listing of none protected page with list=allpages
https://bugzilla.wikimedia.org/show_bug.cgi?id=18770 Reedy changed: What|Removed |Added AssignedTo|roan.katt...@gmail.com |s...@reedyboy.net -- 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 18770] listing of none protected page with list=allpages
https://bugzilla.wikimedia.org/show_bug.cgi?id=18770 --- Comment #3 from Reedy 2010-01-11 13:24:04 UTC --- [13:20:06] OK so about the unprotected pages in list=allpages thing [13:20:19] The LEFT JOIN approach you and Bryan came up with is the right one [13:21:00] I'm not 100% sure about its efficiency and scalability to Wikimedia levels, but I think it should be OK because protected pages are scarce -- 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 18770] listing of none protected page with list=allpages
https://bugzilla.wikimedia.org/show_bug.cgi?id=18770 Reedy changed: What|Removed |Added CC||s...@reedyboy.net --- Comment #2 from Reedy 2010-01-06 23:29:16 UTC --- Left join the restriction table.. Then only output the page if some restriction col is null for that row? -- 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 18770] listing of none protected page with list=allpages
https://bugzilla.wikimedia.org/show_bug.cgi?id=18770 --- Comment #1 from Bryan Tong Minh 2009-07-12 20:05:56 UTC --- Not really trivial to accomplish this. LEFT JOIN against page_restrictions? -- 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