in reply to Re^2: Generate a regex from text
in thread Generate a regex from text

> Also, if the number of rows in the DB is large, this may result in a giant regex.

Well one hits the limit for the trie optimization, splitting into multiple regexes should be done.

Since   $x =~ /a|b|c|d/ is like  $x =~ /a|b/ or $x =~ /c|d/

i.e. it'll scale well.

But that's lost energy as long as the OP doesn't clarify his energy.

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)
Je suis Charlie!