Addshore added a comment.
https://www.mediawiki.org/wiki/Manual:Hooks/ChangesListSpecialPageQuery could
be useful here
TASK DETAIL
https://phabricator.wikimedia.org/T239192
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Ladsgroup,
Ladsgroup added a comment.
"Using index condition; Using where; Using filesort" that's sad and slow but
it works because the range is small.
but I agree timestamp index does make sense for most wikis but not wikidata.
The query I got from tendril is:
SELECT /*
Addshore added a comment.
Some that are actually provided by mediawiki also work well with USE INDEX:
new_name_timestamp | 21 | NULL |
369847 | Using index condition; Using where; Using filesort
rc_name_type_patrolled_timestamp |
Addshore added a comment.
Looks like a different index would be beneficial here...
The query posted above.
Umherirrender added a comment.
The query works with a smaller limit on result and days
https://www.wikidata.org/wiki/Special:RecentChanges?hidebots=1=unpatrolled=1=1=12%3B120%3B146%3B640%3B828=1=1=1=2
It works also for a single namespace