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 <gohsia...@gmail.com > <javascript:>>: > >> 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 orient-databa...@googlegroups.com <javascript:>. >> 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.