Hi Siang, all hash indexes do not support range queries (they are based on hash of course, not on a tree). But standard NOT_UNIQUE should, so if it doesn't work I suggest you to write a small test case or all the steps to replicate the problem, we'll be happy to look at that.
Thanks 2015-01-30 9:55 GMT+01:00 Siang Hwee Goh <[email protected]>: > Hi Luigi, > > I have tried on NOT_UNIQUE and NOT_UNIQUE_HASH_INDEX. Both also not > working. Based on my understanding from > https://github.com/orientechnologies/orientdb/wiki/Indexes, I thought > that will be the most fit at my scenario. Do you have any suggestion? > Thanks. > > On Friday, January 30, 2015 at 4:43:25 PM UTC+8, Luigi Dell'Aquila wrote: >> >> 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. > -- --- 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.
