Well I never tested SKIP and LIMIT. Did you test it on simpler requests maybe?
To make sure it has no other impact. Am Mittwoch, 10. September 2014 09:23:40 UTC+2 schrieb [email protected]: > > It's a bit urgent, also I am just wondering how/is it possible to use > Rid-limit in this case, since the bigger the @rid the earlier the post is. > Thank you. > > On Tuesday, September 9, 2014 12:21:12 PM UTC+10, [email protected] > wrote: >> >> Firstly I am using the version 1.7.8 downloaded from the >> http://orientechnologies.com. >> >> What is happening is I try to get all the post that a user's friend have >> posted >> >> here is a screenshot of my sql >> >> Select expand(out('posted')) from (select expand(out('friend')) from >> #12:338) order by post_time DESC >> >> >> <https://lh3.googleusercontent.com/--BR060iVOe4/VA5hoB1YSaI/AAAAAAAAAJ0/uVhogj-STwQ/s1600/Screen%2BShot%2B2014-09-08%2Bat%2B9.37.01%2Bpm.png> >> >> >> >> >> >> >> >> I want to only get 2 result and skip some result however, the order is >> incorrect, it is not DESC anymore but rather AEC. >> Skip seems to be working correct by it self, Limit works alright by it >> self too, however they do not work together(look at screen shot), limit 2 >> only gives one result. >> >> >> <https://lh3.googleusercontent.com/-d3BR2JqI3fI/VA5kBEPovCI/AAAAAAAAAKA/NYuRaNDCNGs/s1600/Screen%2BShot%2B2014-09-08%2Bat%2B9.37.18%2Bpm.png> >> >> -- --- 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.
