https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Max Semenik <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Severity|enhancement |major --- Comment #5 from Max Semenik <[email protected]> --- Just noticed Wikibase\TermSqlIndex::getMatchingIDs queries taking over a minute in production - this needs to be fixed. (In reply to comment #3) > I think your proposed indexes should be good, but please limit the length on > term_search_key. Most queries use a few letters only ('abc%'), indexing > term_search_key(6) should be good. UTF-8 can take up to 4 bytes for some characters, so this limit would cover 1.5 chars for some languages. -- 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
