The segment editor forces fulltable scans via the ‘contains’ rule. The resulting sql command searches via
like concat('%', 'phrase', '%')
. Is it possible to add something to force a search from the beginning, lets say
^phrase
will generate a
like concat('phrase', '%')
to reduce fulltable scans and offer the oportunity to create an index accordingly? Looking into nearer future, MariaDB or Mysql 5.6.x are assisting fulltext searches via the sphinx engine. Wouldn’t that be a performance gainer for this ‘like’ searches?