Hi Vladimir, You are right only Lucene indexes support such search.
In your single query solution you use OR operator, optimization of which is not supported by QueryOptimizer yet. So search can't be executed in efficient way. What is strange is that the result is incorrect. I suppose operator LUCENE is not working correctly when index can't be used. Could you post a bug to orient-lucene? Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014-06-18 13:00 GMT+03:00 Vladimir Ziankevich < [email protected]>: > Thanks, Artem! > I have also already tried your solution. It works fine. But I think > UNIONALL is not so natural for graph databases. > > Also I don't understand why > > select from Location where name LUCENE 'Lon*' or out_language.in.name > LUCENE 'Lon*' limit=20 > does not work. > > среда, 18 июня 2014 г., 10:29:33 UTC+3 пользователь Artem Orobets написал: >> >> Hi Vladimir, >> >> In this case traverse is not really needed and might lead to unnecessary >> record reads. I also don't think that you need order by in that place. So I >> would transform query to following: >> SELECT EXPAND( $c ) >> LET $a = (select in('language') from Alias where name LUCENE 'Minsk*'), >> $b = ( SELECT FROM Location where name_en LUCENE 'Minsk*' ), >> $c = UNIONALL( $a, $b ) >> >> >> >> Best regards, >> Artem Orobets >> >> *Orient Technologies the Company behind OrientDB* >> >> >> 2014-06-18 9:29 GMT+03:00 Riccardo Tasso <[email protected]>: >> >>> Why are you using Lucene if you don't need full-text features? >>> >>> I would try with: >>> >>> SELECT FROM Location WHERE name LIKE 'Lon%' OR >>> out('language').name LIKE 'Lon%' LIMIT 20 >>> >>> >>> 2014-06-17 13:58 GMT+02:00 Vladimir Ziankevich <[email protected]>: >>> >>> Ouch, I was mistaken. The second query makes search only throough the >>>> aliases. I think that is a correct variant of the second query >>>> >>>> SELECT EXPAND( $c ) >>>> LET $a = (select from (traverse * from (select in_language from Alias >>>> where name LUCENE 'fr_tord*') while $depth <=2) where @class='Location' >>>> order by name_en), >>>> $b = ( SELECT FROM Location where name_en LUCENE 'Minsk*' ), >>>> $c = UNIONALL( $a, $b ) >>>> >>>> But the main question is still not answered. Is there any way to make >>>> similar search without traversing? >>>> >>>> вторник, 17 июня 2014 г., 13:22:00 UTC+3 пользователь Vladimir >>>> Ziankevich написал: >>>> >>>>> I have the next database schema: >>>>> >>>>> vertex type Location(properties: id, name) >>>>> vertex type Alias(properties: name) >>>>> edge type Language(properties: name) >>>>> >>>>> Each vertex of Location can have multiple edges with Aliases. >>>>> For example: >>>>> location(1,London) -> edge language(name='english') >>>>> -> alias(name='City of London') >>>>> -> edge >>>>> language(name='french') -> alias(name='Londres') >>>>> >>>>> There are about 600 000 locations and more than 1 000 000 aliases. I >>>>> need to implement fast search of locations through the location names and >>>>> aliases for typeahead. >>>>> I've applied Lucene indices both to Location.name and Alias.name and >>>>> expected to get appropriate locations list running query like: >>>>> >>>>> select from Location where name LUCENE 'Lon*' or out_language.in.name >>>>> LUCENE 'Lon*' limit=20 >>>>> something like that. >>>>> >>>>> But it does not work. This query returns all the locations from >>>>> database. >>>>> >>>>> I've found another one query that works correctly >>>>> >>>>> select from >>>>> (traverse * from (select in_language from Alias where name LUCENE >>>>> 'Lon*') while $depth <=2) >>>>> where @class='Location' >>>>> >>>>> but I'm worried about the performance. >>>>> >>>>> Could someone offer me another variants? Or how to tune this one query. >>>>> Thanks in advance. >>>>> >>>> -- >>>> >>>> --- >>>> 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. >>>> >>> >>> -- >>> >>> --- >>> 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. >>> >> >> -- > > --- > 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. > -- --- 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.
