@Luigi: Excellent. Thanks for the quick and detailed response! --Eric
On Wed, Jul 22, 2015 at 8:21 AM, Luigi Dell'Aquila < luigi.dellaqu...@gmail.com> wrote: > 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 a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/s7DO-_gygh0/unsubscribe. > To unsubscribe from this group and all its topics, 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.
