29th March 2021, 7:03 PM
(This post was last modified: 29th March 2021, 7:41 PM by bls1999. Edited 5 times in total.)
I fixed the problem with not being able to search for the literal words for numbers. As it turns out, the engine the database was using for the levels table (MyISAM) had certain words that couldn't be searched (AKA "stopwords"), so I changed it to a different one (InnoDB). A full list of stopwords for both engines is here: https://dev.mysql.com/doc/refman/5.7/en/...words.html.
By changing to InnoDB, the minimum character threshold was automatically lowered to 3 (instead of 4) for searches. That means that concern #1 in OP was fixed as a result of the fix for #3.
Concern #2 is proving to be a bit more difficult to fix. I can change the search mode to natural language from boolean which will fix it, but operators like quotation marks (for literal matches), minus signs (to exclude words), etc. won't work anymore. The next question, though: do we care? Or rather, which do we care about preserving more?
Thanks for outlining all the problems with the search function, @Dexterity! This was a long-overdue change.
Edit: It looks like quotation marks still work, which is enough for me. I'm gonna call concern #2 fixed.
Edit #2: Okay, it seems like I have some work to do on the sorting. Also, title searches seem to be significantly slower now. I'll work on this a bit more tonight.
By changing to InnoDB, the minimum character threshold was automatically lowered to 3 (instead of 4) for searches. That means that concern #1 in OP was fixed as a result of the fix for #3.
Concern #2 is proving to be a bit more difficult to fix. I can change the search mode to natural language from boolean which will fix it, but operators like quotation marks (for literal matches), minus signs (to exclude words), etc. won't work anymore. The next question, though: do we care? Or rather, which do we care about preserving more?
Thanks for outlining all the problems with the search function, @Dexterity! This was a long-overdue change.
Edit: It looks like quotation marks still work, which is enough for me. I'm gonna call concern #2 fixed.
Edit #2: Okay, it seems like I have some work to do on the sorting. Also, title searches seem to be significantly slower now. I'll work on this a bit more tonight.
