Slow pagination on links?

[Khaled Bakhit]

Hello all,

I'm using Orientdb 2.0.10, and I'm having performance issues when I want to perform pagination on edges.

I have the following set up ( using Light weight edges, 4 clusters round robin selection per class) :

User ( userid, country )
Movie ( movieid, name )
Likes
User -- Likes ---> Movie

Query:

SELECT in("Likes").size() FROM Movie WHERE movieid=1

Result: 

size= 1138860   in 169 ms

Query:

SELECT in("LIKES")[0-100] FROM Movie WHERE movieid=1

Returns in

 280 ms

Query:

SELECT in("LIKES")[2000-2100] FROM Movie WHERE movieid=1

Returns in ( wow! )

991 ms

Query:

SELECT in("LIKES")[1000000-1000100] FROM Movie WHERE movieid=1

Still loading... :( 

Any suggestions on how to improve performance?  

Eventually, I want to randomly select a subset of Users who likes a Movie per request and do some processing on them.

Thank you in advance.