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

Thanks for this, I had something like trigrams in mind.

But for full automatic regex support one would need to analyse the regex and identify the substrings which are in all execution paths ...

Quite a task.

Though... Perl does some optimisation when compiling its regexes and it's possible to introspect the result. It might be possible to build on this.

On a side note: true, the index adds 150% to the datas size. But the speed gain is dramatic enough to justify it in many use cases.

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

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