Me again. I've been thinking about it some more, and whilst the query I provided works, the performance is probably going to be terrible. Presuming rooms only belong to items, you will effectively be asking the database to load every Item, then every Room, and then a large portion of Users (as it needs to check their name) every time you do this 1 query. That is a lot.
If this is a web app, the best way might be to do 1 query for items, 1 query for the rooms started by the user, then use javascript to add the rooms to each item. -- --- 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.
