Hi Julian, that query is supposed to work using the index, could you post the index definition for a double check? About indexes with multiple keys, that link refers to latest version, but please use this one, that refers to the official documentation (same content anyway)
http://www.orientechnologies.com/docs/last/orientdb.wiki/Indexes.html Luigi 2015-02-10 0:57 GMT+01:00 Julian Klappenbach <[email protected]>: > Also, to answer one of my questions, I did a little more digging in your > index docs, found syntax for multiple key entries here... > > https://github.com/orientechnologies/orientdb/wiki/Indexes > > There's no version information on the docs, so I'm assuming they're the > latest? > > > On Monday, February 9, 2015 at 9:03:09 AM UTC-8, Julian Klappenbach wrote: >> >> >> >> On Monday, February 9, 2015 at 8:53:00 AM UTC-8, Julian Klappenbach wrote: >>> >>> Yeah, >>> >>> select expand(in("Edge1").id) from Class2 where text = 'foo' basically >>> fails, with the server output that the query "fetched more than 50000 >>> records: to speed up the execution, create an index or change the query to >>> use an existent index [OProfiler]" >>> >>> Switching to: >>> >>> select expand(in("Edge1").id) from index:Class1.idxText where key='foo' >>> >>> returns nothing. >>> >>> select from index:Class1.idxText where key='foo' >>> >> >> Sorry, that's "select expand(in("Edge1").id) from index:Class2.idxText >> where key='foo'", and "select from index:Class2.idxText where key='foo'" >> respectively. >> >> -jjk >> > -- > > --- > 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.
