Apparently OrientDB does not provide a performant "like" search capability. Is that correct?
Here's an example. *1) Returns desired results but 10x slow* select from geo where location like "kansas%" "kansas, united states" "kansas city, kansas, united states" "kansas city, missouri, united states" "kansas, illinois, united states" *2) Lucene does not return desired results (for this type of search)* select location from geo where location lucene "kansas*" "kansas, united states" "abilene, kansas, united states" "allen, kansas, united states" "alma, kansas, united states" On Tuesday, January 20, 2015 at 1:11:59 AM UTC-7, Erik Peterson wrote: > > Using 2.0-RC1 > After some experimenting with queries using like, containstext, and > lucene, I have a search where "select from X where like 'abc%" provides the > best results. However it's slow and like can't use indexes correct? Is > there another way to emmulate "like" with lucene indexes? (Note that "select > from X where lucene 'abc*" provides very different search behavior from the > simiar "like" query.) Thanks. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
