As you can see in the second explain the index is not used. I guess that has problem resolving index with dotted notation.
I'm opening an issue about that. https://github.com/orientechnologies/orientdb-lucene/issues/74 2015-10-12 13:07 GMT+02:00 Quan Ngo Minh <[email protected]>: > 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]>: >> >>> 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]. >>> 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.
