Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
AtariAge Posted July 2, 2019 Posted July 2, 2019 On my 3.4.8 forum I was able to use Sphinx to index two-character search terms. I've now jumped to 4.4.x, and I'd like to do that again. I'm currently using MySQL (and will soon be switching to MariaDB) and I know I can set innodb_ft_min_token_size in the my.cnf configuration file and rebuild the search index and that should work. However, I'd like to know how to do this with Elasticsearch. Looking through the code in /system/Content/Search, I see how this works when doing MySQL queries, but I do not know the mechanics of how the search index is created with Elasticsearch, and how the queries are executed. It all looks rather complicated, and nothing obvious has punched me in the face yet. Can someone hit me with a clue stick as far as how I might go about setting up two-character search terms with Elasticsearch? Thanks! ..Al
AtariAge Posted July 3, 2019 Author Posted July 3, 2019 Just to post a followup to this.. I setup Elasticsearch yesterday and the English analyzer that Invision is using does appear to index one and two character search terms. I'm able to do searches I never could previously run on my forum and get meaningful results for, such as "Playstation 1" (with the quotes). It's also very fast--the Elasticsearch node data is sitting on an SSD NVMe drive, which probably helps. I get 10,000 results (the maximum it will return) nearly instantly. The English stemming is nice as well. I'm quite satisfied with the results so far. 🙂 Additionally, the search index rebuilt much, much faster with Elasticsearch versus MySQL. This should also help reduce the load on the database server. Thank you Invision for making this option available! ..Al
Recommended Posts
Archived
This topic is now archived and is closed to further replies.