Hi, I was very excited about OrientDB beacuse of features but I get more and more frustrated because of slow performance for simple queries. For example, I have about 130.000 vertices in MeasurementValue class. I have NOTUNIQUE index on date property. This simple query:
select mea from MeasurementValue where date = '2014-07-19' unwind mea limit 1000 takes 12.4 seconds which is unacceptable beacuse it has index on date property and returns only 1000 rows. There are total of only 365 vertices with date '2014-07-19' in database and each vertex has 96 values in mea embedded list. Also it is very easy to run out of memory (default Xmx512m) if I want to return all rows (365x96 = 35.040 rows). You can download database from: https://drive.google.com/file/d/0B0lGOaunkbGDLWU0ZkNqLVpzSWc/view?usp=sharing Ivan. -- --- 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.
