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.
