Hi, I think the difference in performance is due to two factors: - MATCH statement is a new addition in the engine, so it still has some sharp edges. You can expect important improvements in absolute performance and in integration with the rest of SQL in next releases - if you are executing the query in Studio, the MATCH alone will return only 20 elements by default (that is typically very fast), while if you use it as a subquery for a select, it has to do the full execution and then pass the result to the upper level. This can be optimized of course and I'm working on it.
Two questions: 1. could you please post your query? maybe it can be rewritten with the MATCH only... 2. could you provide the example that fails with aliases in the RETURN? They are supposed to work fine, if it's not the case I'll fix it... Thanks Luigi 2016-07-21 21:10 GMT+02:00 Tore <[email protected]>: > 1) Match works beautifully(once I got the hang of it). However as > suggested in the otherwise excellent blog post, "Pattern matching with > OrientDB", > select something from (match .....) takes ages while the match itself > (i.e. without select) returns in milliseconds. How come? > > 2) In the same example(above) select from (match ,) the suggested return > of aliases, as RETURN A as a, B as b; do not work (2.2.4). > > Finally - a tiny detail at towards the very end of in the same blog, > "Remember always have to use RETURN $elements or RETURN $pathElements". > > *Thank you Luigi! *That really saved my day (just like the day when I > discovered . in vi, to repeat last command) Hurray! > > > -- > > --- > 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.
