I'm using version 2.1.3.
I copied and pasted explanations of two queries:
explain select out.writing from word_language where in.abbreviation = 'vi'
and out in (select from Word where writing lucene 'tru*')
{
"result": [
{
"@type": "d",
"@version": 0,
"documentReads": 18,
"fullySortedByIndex": false,
"documentAnalyzedCompatibleClass": 18,
"recordReads": 18,
"luceneIndex": true,
"fetchingFromTargetElapsed": 15,
"indexIsUsedInOrderBy": false,
"score": 1,
"current": "#17:15",
"totalHits": 2,
"Word_writing_totalHits": 2,
"_memoryIndex": "writing:\n\t'[74 72 75 6e 67]':1:
[(0)]\n\tterms=1, positions=1, memory=32.9 KB\n\nfields=1, terms=1,
positions=1, memory=65.7 KB",
"involvedIndexes": [
"Word.writing"
],
"limit": -1,
"evaluated": 18,
"user": "#5:0",
"elapsed": 15.819102,
"resultType": "collection",
"resultSize": 2,
"@fieldTypes":
"documentReads=l,documentAnalyzedCompatibleClass=l,recordReads=l,fetchingFromTargetElapsed=l,score=f,current=x,involvedIndexes=e,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 0.111 sec. Returned 1 record(s)"
}
explain select out.writing from word_language where in.abbreviation = 'vi'
and out.writing lucene 'tru*'
{
"result": [
{
"@type": "d",
"@version": 0,
"documentReads": 16,
"current": "#17:15",
"documentAnalyzedCompatibleClass": 16,
"recordReads": 16,
"fetchingFromTargetElapsed": 37,
"evaluated": 16,
"user": "#5:0",
"elapsed": 37.729843,
"resultType": "collection",
"resultSize": 0,
"@fieldTypes":
"documentReads=l,current=x,documentAnalyzedCompatibleClass=l,recordReads=l,fetchingFromTargetElapsed=l,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 0.121 sec. Returned 1 record(s)"
}
On Monday, October 12, 2015 at 4:18:12 PM UTC+7, Enrico Risa wrote:
>
> Hi Eddy
>
> which version are you using of OrientDB?
>
> can you paste here the explain of the second query?
>
> explain select out.writing from word_language where in.abbreviation =
> 'en' and
>
> *out.writing lucene 'tru*'Enrico*
>
> 2015-10-12 10:33 GMT+02:00 Eddy Fosman <[email protected] <javascript:>>:
>
>> I have a class named Word and property "writing " with lucene index. The
>> second class name Language with property 'abbreviation' like
>> 'en','ja','es'... The edge "word_language" is linked between them.
>> I just wonder why this query works perfectly:
>>
>> select out.writing from word_language where in.abbreviation = 'en' and
>>
>> *out in (select from Word where writing lucene 'tru*')*but in this
>> query, nothing is returned:
>>
>> select out.writing from word_language where in.abbreviation = 'en' and
>>
>> *out.writing lucene 'tru*'*I could use the first query, but I'm afraid
>> of some performance issues. Could anyone tell me the problem of second
>> query?
>>
>> --
>>
>> ---
>> 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] <javascript:>.
>> 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.
