Hi Eric, at this stage the query executor is not smart enough to understand that the two syntaxes have the same meaning, it just executes some of the elaboration steps (eg. square bracket filtering) the way they are declared. There are very important plans about this in the roadmap. In 2.1 we rewrote the SQL parser (one of the reasons is to allow more flexible usage of conditions in square brackets) and in next release we will also rewrite the query executor. We have many goals to do this: 1. better query language consistency and validation 2. support of more complex queries (eg. with complex conditions in square brackets, or with parameter passing also in subquery - already supported) 3. improved execution planning 4. easiness for future optimization 5. (spoiler) support for declarative querying (pattern matching)
Luigi 2015-07-22 15:10 GMT+02:00 Eric24 <e...@24x8.com>: > 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. > -- --- 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.