Hi Stefan, I was thinking that one way I can do it is to create sorted index on (user_id, follower_id, date_created) and then select PAGE_SIZE entries form it. Rest is easy - fetch selected entries and pass them to web page for rendering. I’m still not sure if this is practical so any advice from community will be helpful.
Thanks, Andrey > On 19 мая 2015 г., at 17:02, [email protected] wrote: > > Hi, > > As far as I know there is no way to do that without: > - Scanning all the "incoming classes" edges > - Fetch the edges + vertexes > - Keep them all in memory while they are being sorted > - Return the top n edges/vertexes > > This happens behind the scenes and is not problematic on the query side but > it is on the performance side. > > This is one of the issues we have come across when working with dense graphs > and the changes, needed to fix this, are on the backlog. > > I would love fore someone to tell me that I'm terribly wrong here. > > Regards, > -Stefan > > > On Monday, 18 May 2015 14:58:17 UTC, Andrey Verbin wrote: > Hi there! > > Let say I'm building something like Twitter. There is a User with 20000 > followers modeled as a relationships between User and Follow classes. Every > user reference N Follow instances which in turn has a link to follower user > and also creation date. I want to display paginated list of followers but not > sure how to do it with OrientDB. What would be the best way to display > paginated list of such followers sorted by creation date? > > Thanks > > -- > > --- > You received this message because you are subscribed to a topic in the Google > Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/5HXM9ysEIsE/unsubscribe > <https://groups.google.com/d/topic/orient-database/5HXM9ysEIsE/unsubscribe>. > To unsubscribe from this group and all its topics, send an email to > [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- --- 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.
