search - Embedded List Query Performance In OrientDB -

maybe simple question orientdb, because i'm using few days.

my question is, have million documents(let's called classa) in orientdb, , every document has field(let's called fielda).

fielda's type embedded list, , item in embedded list string.

so, data in orientdb this:

[     {         fielda: ['a','b','c']     },     {         fielda: ['c','d','e']     }, ] 

what want query document fielda.

so query this:

select classa 'c' in fielda 

because, there millions of records in database, created index fielda, script created index this:

create index classa.fielda not unique 

but when explain select query, got this:

{     "@type":"d","@version":0,      "involvedindexes":["classa.fielda"],      "current":"#11:960477",      "fetchingfromtargetelapsed":160596,      "documentreads":959211,      "documentanalyzedcompatibleclass":959211,      "recordreads":959211,      "elapsed":160596.25,      "resulttype":"collection",      "resultsize":1,      "@fieldtypes":"involvedindexes=e,fetchingfromtargetelapsed=l,documentreads=l,documentanalyzedcompatibleclass=l,recordreads=l,elapsed=f"  } 

as can see in result, if used index ["classa.fielda"], 959211 records, query last 160596 ms, 16 seconds. slow(compare mysql, mysql, records larger, because mysql didn't support embedded list, storage mysql every fielda, has record in mysql, , query fast, cost 0.015 seconds).

am did wrong? or performance of embedded list query in orientdb bat?

can has deep understanding of orientdb , orientdb index me this?

mysql returns cursor right after query paginating them, when fetch records results different. please try

select count(*) classa 'c' in fielda 

on both orientdb , mysql or try fetch records.