in reply to Re^4: Documentation of REGEXP support in DBD::SQLite?
in thread Documentation of REGEXP support in DBD::SQLite?
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
|
|---|