in reply to Re^2: storing a qr// compiled regexp in a database?
in thread storing a qr// compiled regexp in a database?

A "precompiled regex" is mostly a string, at least from the Perl view of things. And the best you could do to save a regex in a database is to stringify it and then recompile it from that string anyway.

I think you're looking in the completely wrong direction if you're trying to optimize such minor things. Have you profiled your application already? Does it really spend that much time on compiling (and recompiling) regular expressions? Maybe you should reduce the number of regular expressions then. A good profiling tool is Devel::Dprof. It's also the only profiling tool.

  • Comment on Re^3: storing a qr// compiled regexp in a database?

Replies are listed 'Best First'.
Re^4: storing a qr// compiled regexp in a database?
by ManFromNeptune (Scribe) on Sep 17, 2005 at 21:52 UTC
    Ok, I think this is sound advice. I haven't used Dprof, but I have done some more hackish profiling with TimeHiRes. Since my regexes are actually user-defined, I notice that in some cases they take an enormous amount of processing... for example, a 60kb web page will consume 18 minute of CPU time crunching a complex regex! But the stem of the problem is that I don't have much control over the regex that the user defines, hence I'm still looking for any perf gains. Perhaps I should devise a way to help optimize the users' regular expressions (probably not a simple thing to do aside from end user education.)

    Anyways, this is a classic case of programmer (me) vs. end user (with wacky regexes.) Sigh...
[reply]
[reply]

In Section Seekers of Perl Wisdom