On en.wiki, using a 7-day search
- add the following to the default filters: "Very likely good faith" + "Likely have problems."
- **Result:** after about 2.5 minutes, found some two-dozen results.
The issue here would seem to be that this is a fairly rare event on some wikis. E.g., 23 in 7 days on en.wiki. On other wikis it is less rare: e.g., pl.wiki, this search brings up results pretty readily. And, of course, other wikis are not as big as en.wiki.
Despite being sometimes rare, this is a perfectly valid search. In fact, it's precisely the type of search--looking for problems made by good faith editors--we is exactly what we hoped users of the New Filters beta would do.
This is not the only search that takes a long time.e issue here would seem to be that this is a fairly rare event on en.wiki: I found only 23 in 7 days. And, of course, other wikis are not as big as en.wiki. On pl, cs and he, this search works fine and gets lots of results. On ru.wiki, it's slow but searching back 7 days takes about a minute. en.wiki is by far the worst, with the search taking many minutes, often finding nothing, and, one time I tried it, But it is one of the longer ones I found,failing altogether ([WZ4J2wpAAEMAAEW2y20AAACK] 2017-08-23 23:04:55: Fatal exception of type "Wikimedia\Rdbms\DBQueryError" )
(There are other searches that take a long time. and it's certainly one of the more important and valid ones (eE.g., "very likely good" + :Very likely bad faith"." But that one is arguably invalid and could just be short circuited. See T164292 )
What can we do to make such searches —and this one in particular—faster?
(See related task T164621 )