Aha! Interesting that the bracket syntax is 4X faster than using the WHERE clause. That's a bit surprising, as I would have thought that the query optimizer would have arrived at the same execution plan for either syntax, since they are functionally the same.
Anyone from Orient care to comment on: a) Why the speed difference? and b) Why the bracket syntax has the limitations it does, when it's possible to express those queries using the WHERE clause? --Eric On Wednesday, July 22, 2015 at 2:18:10 AM UTC-5, alessand...@gmail.com wrote: > > Hi, > at this link http://orientdb.com/orientdb-improved-sql-filtering/ > I have founded Squared brackets [] allow to: > - filtering by one index, example out()[0] > - filtering by multiple indexes, example out()[0,2,4] > - filtering by ranges, example out()[0-9] > - filtering by equal conditions (only equals is supported), example > out()[@class = ‘Person’] > > Regards, > Alessandro > -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
