Il 01/07/2016 19:28, Luca Garulli ha scritto: > Please use 2.2 because it's much much faster, specially on scan + parallel.
Ok, Luca. > I can help you with queries if you can tell me what do you want. Or the > same query in MySQL? This is a simple query that I've tested for this moment: select count(*) as total from drug, demo where drug.primaryid = demo.primaryid and demo.age > 29 and demo.age < 46 and drug.drugname = 'TRIZIVIR' In OrientDB I've tried this: select count(*) as total from ( select expand(in()) from demo where age > 29 and age < 46 ) where drugname = 'TRIZIVIR' that return correct result, but I think that the use of subquery is not efficient. What do you think, Luca? -- 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
