https://bugzilla.wikimedia.org/show_bug.cgi?id=25931
--- Comment #21 from Sumana Harihareswara <[email protected]> 2012-04-25 18:19:19 UTC --- Some discussion in IRC just now (#mediawiki): <sumanah> "Waiting for database administration review by Asher Feldman, waiting for author Victor Vasiliev to move extension to Git." bug https://bugzilla.wikimedia.org/show_bug.cgi?id=25931 in https://www.mediawiki.org/wiki/Review_queue#Extensions <vvv> Well <vvv> I think it would fail the first stage <vvv> Because it uses an unindexed query IIRC <RoanKattouw> It's also not really indexable <RoanKattouw> Unless you add a cl_random field to categorylinks <vvv> Yes, this is the problem we found back in 2007 <RoanKattouw> As written it'd have to fetch all categorylinks rows for a given category, join them against page, then do a range scan on page_random <RoanKattouw> The range scan may or may not be indexed, I couldn't say offhand, but joining an entire category against the page table is a problem when you consider stuff like [[Category:Living people]] <vvv> Well, it was not even me who split it as an extension <RoanKattouw> (I'm assuming the query is something like SELECT stuff FROM categorylinks, page WHERE cl_to='Category_name' AND page_id=cl_from AND page_random > 0.123 ORDER BY page_random LIMIT 1; ) <vvv> I believe someone made it after the original version was reverted <vvv> And cl_random would sound something you would want to have in core <RoanKattouw> That would probably want to be in core yeah <RoanKattouw> But adding cl_random is an expensive operation <vvv> RoanKattouw: I remember nobody wanted to do it because switching masters were done manually back then <RoanKattouw> Still, switching masters is not what people do for fun <RoanKattouw> To me it just seems like a lot of effort for a minor feature <RoanKattouw> OTOH on smaller wikis it might work, but when Sumana and I talked to Asher about this last night he said he didn't want to assume that small wikis will stay small forver <RoanKattouw> It would be particularly ironic if we enabled it on some Indic language wiki because it's small, while 3 floors above me there's people whose job it is to try and get that wiki to grow <binasher> vvv: RoanKattouw: if the query is like what roan mentioned above, -1. this sort of thing should be done with a search engine and is probably even doable with the one we have -- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
