I am evaluating OrientDB right now and I tried to inserts 1.2 million simple records inside one of the database. It is an Employee class with just few columns.
When I tried to perform the query on SELECT * FROM Employee WHERE salary = 1343 it was very slow and ended up no result being returned. I did some indexing and now it became very fast. However, when I tried to again change the query a little bit to this SELECT * FROM Employee WHERE salary >= 3330 AND salary <= 3330 it ended up return nothing again and prompted me the transactions is more than 50,000 records and ... As a matter of fact, there is only 1 record inside which fulfill this search criteria. Could anyone let me know how to tune the performance in such case? Thanks. -- --- 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.
