I can't see how LIKE with a wildcard could possibly use the index. It would need to read the field for every record and check if it matches the pattern.
On 16/02/14 21:07, Pavel Hromadka wrote: > Hi All, > > i've been playing with ODB for a while, i liked it very much! > So i've decide to try performance. > > Scenario: > ------------- > > My classes: > V -> ipsListing(...) -> ipsListingCompany(AliasName:string) > > I've imported about 3.4M rows into ipsListingCompany, then defined > INDEX (NONUNIQUE on AliasName) > > Query: > > select * from ipsListingCompany where AliasName like 'ATONA%' > > Result tooks about 5 mins!!!!! This is not acceptable.. what i do > wrong? :( > > > Thanks for any hint/s. > > Pavel > > > -- > > --- > 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/groups/opt_out. -- --- 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/groups/opt_out.
