Thank you! On Monday, October 12, 2015 at 6:19:32 PM UTC+7, Enrico Risa wrote: > > 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] > <javascript:>>: > >> 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] <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.
