Could you please tell me what is proper way to search 1-N relationship in document database? Assume that we have Firm Class with field 'client_links' (LINKSET, class @rid=#10:0), and I need to find subset of the firm's clients from London. Also I want to get just part of the result set, that user see. A new part should be shown when he click a button 'Next part'.
My query: SELECT FROM (SELECT EXPAND(client_link) FROM #10:0) WHERE city='London' SKIP 160 LIMIT 20; but I guess, that there is better way to make the query, or to define relationship, because it's slow when client_link is very big. -- --- 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.
