Take also a look at this page: http://orientdb.com/docs/last/Chat-use-case.html
Best Regards, Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB http://about.me/luca.garulli On 25 May 2015 at 19:36, Luca Garulli <[email protected]> wrote: > Hi guys, > We helped on building a high-volume chat application by modeling the > metadata about who started/discuss, but then using the document API with no > index to have super fast access to last X messages. In facts, OrientDB > stores new records in append only, and the @rid is auto generated as > incrementing. So if you just create the message in the chat with > > ODocument msg = new ODocument("Message"); > msg.field( "date", new Date() ); > msg.field( "text", iText ); > ... > msg.save(); > > Then you can retrieve last 50 messages with: > > *select from Message order by @rid desc skip 0 limit 50* > > To load the 2nd (last) page: > > > *select from Message order by @rid desc skip 50 limit 50* > > This is super fast and O(1) even with million of messages. > > > Best Regards, > > Luca Garulli > CEO at Orient Technologies LTD > the Company behind OrientDB > http://about.me/luca.garulli > > > On 25 May 2015 at 16:32, <[email protected]> wrote: > >> Hi Brett, >> try this SQLquery select name,in('Discuss').roomId from (select >> expand(out('Started').out('Discuss')) from User where name = 'julie') >> >> Bye, Alessandro >> >> >> Il giorno sabato 23 maggio 2015 04:17:19 UTC+2, Brett Coffin ha scritto: >>> >>> I am building a chat room engine and I have a graph like so: >>> >>> User---Started--->Room----Discuss--->Item<---Own---User >>> >>> I would like to get all the Items and the roomId associated to the Item >>> for a particular User. >>> >>> select >>> *, in('Discuss').in('Started')[name ='julie'] as roomId >>> from item >>> >>> so this is going threw the right 'Room' and finds the one started by >>> 'Julie' but it returns Julie's Id, how do I get with this query the Id of >>> that room ? It's like i need to do a 'one back' and get @rid... >>> >>> I am new to graphs so any pointers would be appreciated. >>> >> -- >> >> --- >> 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. >> > > -- --- 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.
