Slow pagination on links?

29 views
Skip to first unread message

Khaled Bakhit

unread,
Jul 6, 2015, 8:28:18 AM7/6/15
to orient-...@googlegroups.com

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.




 






Reply all
Reply to author
Forward
0 new messages