Re: [orientdb] compound index seems to be ignored

Hi, I've attached the database export, including the defined index. And here's the query: SELECT @rid FROM User WHERE state=active AND birthdayYear = 1994 AND birthdayYear = 1958 AND ageMin = 59 AND ageMax = 59 AND height = 176 AND height = 161 AND heightMin = 188 AND heightMax = 188 AND

Re: [orientdb] compound index seems to be ignored

Hi, A small sample database and the query you execute will be enough Thanks Luigi 2015-03-05 21:18 GMT+01:00 Máté Gábri gabrim...@gmail.com: Hi Luigi, sorry I'm new to this so please forgive my noob question. What should I provide so that you can test it? My code (nodejs) I'm using for

Re: [orientdb] compound index seems to be ignored

Hi Mate, there are no limitations in the number of properties that can be indexed, so there must be a bug somewhere. Could you provide a test case to reproduce it? Thanks Luigi 2015-03-04 22:25 GMT+01:00 Máté Gábri gabrim...@gmail.com: Hi, I'm trying to get familiar with OrientDB's

[orientdb] compound index seems to be ignored

Hi, I'm trying to get familiar with OrientDB's indexing to make some performance tests. I'm running a query on a class which uses 10+ conditions in the WHERE statement with range selections, constants and IN conditions. I've created the compound index in the same order as the fields appear in