Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE

[runrig]

Making fewer database calls when possible is good. You can also do (if there are not too many @values):

my $sta = 'UPDATE foo SET bar = ? WHERE baz in (", join(',', "?" x @va
+lues), ")";

But I think jZed was just offering a generic example, and on these sorts of updates, I think you often want to set 'bar' equal to something different for each 'baz', so the multiple execution version is more appropriate in that case.