CODEWITHSUNDEEP
mysql
Tum
Tum

Reputation: 3652

Does REGEX query run faster in MyISAM table than in InnoDB?

Select * from Table where text REGEXP '[[:<:]]car[[:>:]]'

Is there any difference in the performance if it is MyISAM table and if it is InnoDB one?

Upvotes: 1

Views: 117

Answers (1)

zerkms
zerkms

Reputation: 255045

They both cause full table scan.

So there is practically no reason to "compare" performance, since the full table scan is already the thing you should avoid.

If you have an intelligence search - use builtin fulltext index or some mature 3rd party ones like Lucene or sphinx.

Upvotes: 1

Related Questions