I'm testing orientdb for a storage database of a knowledge base.
The database can be something like this:
[
{
fieldA: ['a','b','c']
},
{
fieldA: ['c','d','e']
},
]
and the query is something like this:
select from ClassA where 'c' in fieldA
The query is very very slow, the explain of the query is as below
{
"@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 you can see, even OrientDB used the fieldA index, it still costs 16
seconds to query a million records, it is unacceptable.
Is there any good way to make this query faster?
https://stackoverflow.com/questions/22896528/embedded-list-query-performance-in-orientdb
--
---
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.
