Re: [orientdb] The query execution is unstable, sometimes fetch more data

Hi Luca, I am Hung co-worker. These are the results: (1) { "result": [ { "@type": "d", "@version": 0, "fetchingFromTargetElapsed": 0, "expandElapsed": 0, "orderByElapsed": 0, "current": "#20:0",

[orientdb] Re: How to speed up OrderBy with Where

Hello Ivan, This query... SELECT FROM Contact WHERE (OwnedBy.EntityInfo.State <> 200) AND (Account = #20:2) AND (EntityInfo.State = 0) ORDER BY EmailAddress ASC skip 10 limit 10 is explained as { "result": [ { "@type": "d", "@version": 0,

[orientdb] How to speed up OrderBy with Where

Hi, I am using OrientDB 2.1.8 on Windows 2012 server platform. I have a table about 1.117.549 records, with indices as following. Here are some queries

Re: [orientdb] How to speed up ORDER BY

Hi Luigi, (I am a co-worker of Hung, the original author of this post) Thank you very much for your answer. Creating the following index really improved the performance of that query (without @rid in ORDER BY clause). CREATE INDEX Task.PriorityDueTime ON Task (Priority, DueTime) NOTUNIQUE