Hi Siang, which kind of index did you define? Not all types of index support range queries
Luigi 2015-01-30 9:05 GMT+01:00 Siang Hwee Goh <[email protected]>: > 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. > -- --- 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.
