Hello,
In one of our Weaviate-based projects we perform a where query with the Like operator for some fields (title, text) over a large set of objects. As the amount of objects stored in Weaviate for this particular class grows, this query becomes very slow (15s-20s).
There is a note in the documentation specifically for that, but maybe there are some alternatives to this search method? Basically it needs to be a full-text search (or even simple substring-matched search), but it needs to be able to match parts of words as well. We tried BM25 and Hybrid search but they don’t seem to properly match parts of the words, only the full words.