Il 11/07/2016 08:46, Luigi Dell'Aquila ha scritto: > In my experience, there numbers seem a bit too high... > Just a couple of questions (sorry, I don't know if you already answered > before, maybe I missed it...) > - how big is your DB?
Size of DB is 19 GB.
> - what is your configuration? (RAM, heap, off-heap and so on)
> - I see you are using out() without any edge class names, do you have a
> schema defined? Can you try to use edge class names, eg out("TheEdgeClass")?
I have 12 GB of RAM, when I launch OrientDB console I use 8192 MB of
heap space, I dont' know if this information is useful for you.
> Could you also please try to rewrite the queries this way and let me
> know if they are better?
>
> select
> out()[drugname = 'TRIZIVIR'].out()[age > 29 and age < 46].size()
> from indi
> where
> indi_pt = 'HIV infection'
>
> or even better
>
> select
> out("TheEdgeClassName")[drugname =
> 'TRIZIVIR'].out("TheEdgeClassName")[age > 29 and age < 46].size()
> from indi
> where
> indi_pt = 'HIV infection'
Ok, but these queries returns me always 20 records with all values
setted to 0: they are insignificant.
In my first implementation I have loaded all edges into E class: I
reload the DB using more than one subclass for edges. I have rewrited my
query as follow:
select count(*) as total from ( select expand(out('drugToDemo')) from (
select expand(out('indiToDrug')) from indi where indi_pt = 'HIV
infection' ) where drugname = 'TRIZIVIR' ) where age > 29 and age < 46
and results are better: 1.444 sec.
But MySQL returns same result in 0.06 sec.
--
Fabio Rinnone
Skype: fabiorinnone
Web: http://www.fabiorinnone.eu
--
---
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.
signature.asc
Description: OpenPGP digital signature
