![]() ![]() This post is really about how to do a performant text search accross multiple collections (and many, but not all attributes) in the database. I am trying to add a text search to my application and am afraid that using LIKE will result in a full collection scan on every collection on multiple fields (case insensitive) and will not scale. ![]() The functions for fetching all results are listed as bellow: aqlstr This function only accept a AQL query string. These functions internally fetch batch results one after another to get all results. Does ArangoDB support substring searches using indices in any fashion. There are three functions for AQL query that fetch all results from ArangoDB. To demonstrate what I am trying to do and what does not work. I should have provided a sample query such as: FOR node IN FULLTEXT("m圜ollection", "myAttribute", "bcde") ![]() Update: I oversimplified the above query to try and keep it short and understandable. Can someone explain to me what I am missing or what needs to be done to make FULLTEXT("m圜ollection", "myAttribute", "abcde") find my node where myAttribute = "abcdef". The examples in the documentation search for the word "the" in a sentence so I expect that a FULLTEXT() search for "abcde" should match "abcdef". However the following query returns no result: FOR node IN FULLTEXT("m圜ollection", "myAttribute", "abcde") I have a node in m圜ollection with myAttribute = "abcdef" and myAttribute has a fulltext index on it and the above query works just fine and returns one result. I am running a simple query similar to the following: FOR node IN FULLTEXT("m圜ollection", "myAttribute", "abcdef") ![]()
0 Comments
Leave a Reply. |