Hi Curtis can you post the result of
explain select * from Abstract where appln_abstract LIKE "%of a pipe of the pipe%" Thanks Enrico 2014-08-18 17:19 GMT+02:00 'Curtis Mosters' via OrientDB < [email protected]>: > I'm still testing around with OrientDB. Today I realized that OrientDB is > 3 times slower on the same data, with the same indexer compared to MySQL. > How can that be? > > So there are ~250k entries. FULLTEXT indexer are used on both db's. (from > https://github.com/orientechnologies/orientdb/wiki/Indexes) > > And the test query is: > select * from Abstract where appln_abstract LIKE "%of a pipe of the pipe%" > > in OrientDB: 34 sec > in MySQL: 14 sec > > I tested this on them both 3 times and this is the average. > > Any ideas? > > -- > > --- > 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.
