Personally I prefer the first one, the one using place holder.

"From an elegance standpoint, it's nice to have each "IN" item be its own bind parameter,"

Not true, for the elegance, one place holder for the entire in list is better than multiple ones (and one for each element). From an elegance point of view, you don't use dynamic query, unless there is absolutely no other (easier) way. In this case, in order to have the right number of place holders for the elements of the in list, you have to go with dynamic query, which is less perfect.

One purpose of place holder is performance as you mentioned, it is not clear to me whether the latest MySQL actually started to use the true prepared query, but you probably should use it any way for two reasons: 1) other benefits that prepared query bring to table; 2) even if there is no performance benefit with the current MySQL implementation, I believe there will be.

In reply to Re: DBI and variable numbers of bind parameters by pg
in thread DBI and variable numbers of bind parameters by friedo

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.