in reply to Re^8: Documentation of REGEXP support in DBD::SQLite?
in thread Documentation of REGEXP support in DBD::SQLite?

> I can't get bigrams to respond quickly

Hence they are not indexed.

> although its simple pattern search can sometimes use the trigram or btree index

That's why I wanted LIKE, to be sure the trigram optimization can be chosen

Cheers Rolf
(addicted to the Perl Programming Language :)
see Wikisyntax for the Monastery

  • Comment on Re^9: Documentation of REGEXP support in DBD::SQLite?

In Section Seekers of Perl Wisdom