in reply to RegEx Problem?

Unless your definition of "regex" fits with whatever version of SQL your using's LIKE syntax, your going to have to read every line from the DB into memory in order to use perls regex engine. It is almost enevitable that reading from a DB will be less economical than reading a flat file.

Another problems is that, as far as I am aware, no DB will find matches that are split across record boundaries.

I personally think that unless your data has some structure to it that would allow you to make use of the DB facilities beyong storage and retreival, it doesn't make much sense to put it into a DB, but YMMV.


..and remember there are a lot of things monks are supposed to be but lazy is not one of them

Examine what is said, not who speaks.
1) When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he states that something is impossible, he is very probably wrong.
2) The only way of discovering the limits of the possible is to venture a little way past them into the impossible
3) Any sufficiently advanced technology is indistinguishable from magic.
Arthur C. Clarke.