https://bugzilla.wikimedia.org/show_bug.cgi?id=31197
--- Comment #12 from Roan Kattouw <[email protected]> 2011-10-05 16:33:02 UTC --- (In reply to comment #10) > (In reply to comment #9) > I won't pretend to completely understand what has been illustrated here, but > it > would help to put it into simpler words. Does this mean that this particular > feature draws on excess resources that has a deleterious effect on some other > aspect of the project, or does it mean it's inelegant? > > This feature is very heavily used by editors and administrators on a daily > basis (I cannot remember an editing day in the last 3 years when I have not > used it), and thus it's not just a "nice" feature but one on which many of us > rely. It means that depending on how many edits the targeted user has, and how many of those were in the requested namespace, the query may take anywhere between 1 millisecond and 2 minutes. This is because the database can efficiently retrieve all edits by a certain user, but then has to go through them one by one to check the namespace against the requested namespace until it has either reached the number of qualifying edits requested (usually 50) or reached the end of the list of edits. The latter may take a long time for users with many edits. In the example Domas gave, he asked for 10 edits by Rambot in the Template namespace, and it took almost 2 minutes to examine every single edit by Rambot in the entire history of Wikipedia and conclude there were zero edits matching his criteria. And at our scale, queries taking more than a second are already considered slow. -- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
