Hi Luca, Can you please explain why the first one is much faster? Intuitive it looks the same, and it might be a trap for developers ( like us ;) )
On Monday, February 13, 2012 at 5:19:12 PM UTC+2, Lvc@ wrote: > > Alessandro is right, > just note that this > > SELECT FROM [#3:0,#3:1] > > it's much faster than > > SELECT * FROM ORole WHERE @rid in [#3:0,#3:1] > > Lvc@ > > On 13 February 2012 15:48, Greg T <[email protected] <javascript:>> wrote: > >> Thanks Alessandro, that's exactly what I needed! >> >> The multiple (in list) also works nicely now with "@rid": >> SELECT * FROM ORole WHERE @rid in [#3:0,#3:1] >> >> >> On Feb 13, 2:18 pm, Alessandro Nadalin <[email protected]> >> wrote: >> > On Mon, Feb 13, 2012 at 3:14 PM, Greg T <[email protected]> wrote: >> > > Hi >> > > I am new to OrientDb and already impressed (missing only .NET >> > > integration) >> > > But I am having problem with something very simple: what is the syntax >> > > for selecting by RID, eg: >> > >> > > SELECT * FROM ORole WHERE RID = #3:0 >> > >> > SELECT * FROM #3:0 >> > >> > or >> > >> > SELECT * FROM ORole WHERE @rid = #3:0 >> > >> > >> > >> > > I've tried every possible combination but have no idea how to pass the >> > > RID (single and multiple) >> > >> > > Thanks >> > >> > -- >> > Nadalin Alessandrowww.odino.orgwww.twitter.com/_odino_ >> > > -- --- 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.
