Hi, Andrey.
Thanks for your reply. The memory information is as below:
[root@root ~]# cat /proc/meminfo
MemTotal: 8063160 kB
MemFree: 228968 kB
As you can see
"involvedIndexes":["ClassA.fieldA"],
"current":"#11:960477",
"fetchingFromTargetElapsed":160596,
"documentReads":959211,
Even the database can see the index, but it still iterate all the documents
in the database, I think that's the reason for the slow.
The same data in mysql(that using fieldA's index), can return data in
0.015second, so I think this is not the fault of the data, maybe there is a
better way for creating index or querying using index for embedded list of
OrientDB.
On Monday, April 7, 2014 5:25:27 PM UTC+8, Andrey Lomakin wrote:
>
> Yes too slow.
> What amount of RAM do you have ?-
>
>
> On Mon, Apr 7, 2014 at 5:33 AM, Wise Jack <[email protected]<javascript:>
> > wrote:
>
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Best regards,
> Andrey Lomakin.
>
> Orient Technologies
> the Company behind 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.
