https://bugzilla.wikimedia.org/show_bug.cgi?id=44773

--- Comment #6 from Thiemo M├Ąttig <thiemo.maet...@wikimedia.de> ---
I finished refactoring the related code in several patches but unfortunately
had to abandon the draft that was supposed to fix this issue. My initial idea
was to simply do an additional WHERE LIKE '%<search term>' if the other three
requests that are currently done do not return enough results (basically WHERE
id = '<search term>' concatenated with WHERE term = '<search term>'
concatenated with WHERE term LIKE '<search term>%').

This is a bad idea for multiple reasons:
1. Ranking will be bad. The "contains" results will always be hidden behind the
"equals to" and "starts with" results.
2. It should probably be different for Items and Properties.
3. LIKE queries don't use any indexes if they start with a placeholder.

To make this a proper solution the least thing we need to do is to split labels
into words (or come up with a more clever solution like identifying common
prefixes like "date of" and turn such labels into "birth, date of"). Then we
can add these individual words to our term index.

The current solution to do exactly that is very intuitive and simple: add
aliases.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to