Unfortunately I don't have access to a mod_perl server, however it's reasonable to assume initially that it's not a mod_perl specific problem, unless you also ran benchmarks on a non-mod_perl server; remove layers of complexity to isolate the problem.

I have run some more benchmarks, first I changed the WHERE clause to use a text column and tried it using bind and using non-quoted inline, such as tye suggested was a syntax error.

This actually resulted in using bind being faster.

Results 

> ./test.pl 
Benchmark: timing 50000 iterations of bind, inline...
      bind: 55 wallclock secs (19.04 usr +  8.97 sys = 28.01 CPU)
    inline: 81 wallclock secs (20.21 usr + 11.32 sys = 31.53 CPU)

[download]
Code 
sub xbind {
  my $sql = 'SELECT edited FROM faq WHERE q = ?';
  my $sth = $h->prepare( $sql );
  $sth->execute( 'q' );
  
  my $res = $sth->fetchall_arrayref;
  $xbind = @{$res};
}

sub xinline {
  my $sql = 'SELECT edited FROM faq WHERE q = q';
  my $sth = $h->prepare( $sql );
  $sth->execute;
  
  my $res = $sth->fetchall_arrayref;
  $xinline = @{$res};
}

[download]
So, I modified it to check how many rows were being returned, the bind version was returning 1, the inline version was returning all rows.

My mysql version is 3.23.49, DBI version 1.30 - completely different generation of db than you, so tests are not equal.
So if you got the same results with these tests, then you should try adding back in layers such as mod_perl, to see which is to cause.

In reply to Re: Re: Re: mod_perl was hosed by a bind variable by fireartist
in thread mod_perl was hosed by a bind variable by phildog

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.