daniel added a comment. I feat that MySQL doesn't fully index varchar fields wider than 255 characters (or even bytes?). And I'm unsure if it's smart enough to fall back to prefix search and post-processing. I seem to recall that this doesn't work. Can you compare the output of EXPLAIN for the relevant queries with and without this change?
TASK DETAIL https://phabricator.wikimedia.org/T99459 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: daniel Cc: Krenair, jcrespo, Springle, Lydia_Pintscher, aude, daniel, Aklapper, hoo, Wikidata-bugs _______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs