hi, i tried your db, leaving everything as it is and making the query I got this result:
<https://lh3.googleusercontent.com/-Zp-no9vWfaQ/VcC2V3VyoyI/AAAAAAAAAFg/cnohdH-IFW0/s1600/sbtree.png> SBTREE To speed it up you could delete the index of date and recreate it by putting it as Type: NOT UNIQUE HASH INDEX (should be the fastest of all and you can use it since there aren't ranges of queries). Putting this index was 15% faster than the previous time, putting 2.775 seconds. This is the result obtained: <https://lh3.googleusercontent.com/-Uo4-Jt9m26k/VcC4q6311iI/AAAAAAAAAF0/kA7Xn0NOA8g/s1600/hashindex.png> HASH INDEX have you got some improvement? regards, Savio L. -- --- 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.
