https://bugzilla.wikimedia.org/show_bug.cgi?id=65332
--- Comment #4 from MZMcBride <[email protected]> --- (In reply to Sean Pringle from comment #3) > There isn't a useful index on rev_user_text /to/ force :) Ah, fair enough. For the bug's reference, according to <https://git.wikimedia.org/raw/mediawiki%2fcore%2egit/HEAD/maintenance%2ftables%2esql> MediaWiki core has: CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision (rev_user_text,rev_timestamp); CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); > afaik these results are already cached so this doesn't need to be instant, > just tolerable. I guess I need to trial adding a page_usertext_timestamp > index and report back. I guess this page_usertext_timestamp index would be a combination of usertext_timestamp and page_user_timestamp and would be a custom index for (all?) Wikimedia wikis. Won't this be a very large index for the very large revision tables? I'm not sure this feature is worth it, but this is most definitely your area of expertise and not mine. :-) -- 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
