Last modified: 2009-08-02 14:29:52 UTC
Currently recent changes has two modes First is unfiltered edits by human and bot-flagged not-so-human editors. Second is filtered edits by human editors. Basically edits by flagged bots are not shown. There should be a third option allowing me to filter out human edits so that I can review edits that are only bu bot-flagged accounts.
We have no index on rc_bot. This might not be acceptable unless that's fixed, except on wikis with a high percentage of bot edits. Worst case is a table scan if there are no bots in the history of the project.
You can just pull the not of how you pull bot edits. You have the entire RC feed, you have the human only edits. Everything - Human edits = Bots? Some people want to exclusively review bot edits to check if the break. I think such an option would have benefit to the project.
It's just the negation of a statement, but that doesn't mean it's not worse for performance. WHERE id = 8 retrieves one row and is very fast, WHERE id != 8 retrieves the whole table minus one row and is very slow. Same sort of thing here, although a little less extreme. It's very unlikely that a typical wiki will have more than, say, 50% bot edits. Therefore, *hiding* bot edits will likely read a maximum of twice as many rows as are actually needed, which isn't terrible. But it's very likely that many wikis have almost no bot edits, or literally no bot edits, and this means that showing *only* bot edits will have to scan the recentchanges table, which is bad. It might be acceptable anyway. Large wikis will usually have at least one bot, and scanning the recentchanges table of a small wiki isn't so bad. Plus this option is not likely to be commonly used. But I wanted to point out that it's not necessarily obvious that this is okay.
Fixed in r32696.
*** Bug 12781 has been marked as a duplicate of this bug. ***
