select(row|all) will prepare and execute a query in one step. That’s handy when you only need to run a query once, but if you repeat it, it will re-prepare the query every time.

If you prepare the query manually, you can execute it repeatedly without preparing it more than once.

Makeshifts last the longest.

EDIT: Oh, I see what you want to know. Use IN and fetchrow rather than multiple selectrows.

Alrighty then. How do these two compare? (all strict, of course)

$stmt = "SELECT * FROM mytable WHERE id = $myid";
$sth= $dbh->prepare($stmt);
$sth->execute;
$results = $sth->fetchall_arrayref({});

__versus__

$stmt = "SELECT * FROM mytable WHERE id = $myid";
$results = $dbh->selectall_arrayref($stmt);
[download]

Advantages of one over the other?


—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot

Note that you should probably use placeholders. It’s so easy with DBI that there’s rarely a reason not to.

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $sth = $dbh->prepare( $stmt );
$sth->execute( $myid );
my $results = $sth->fetchall_arrayref( {} );

# or

my $stmt = "SELECT * FROM mytable WHERE id = ?";
my $results = $dbh->selectall_arrayref( $stmt, undef, $myid );
[download]

Then you can also further optimise the first case by saying

my $sth = $dbh->prepare_cached( $stmt );
[download]

In that case, because the placeholder-adorned query is always the same, you might even end up preparing the statement only once during your entire runtime.

Makeshifts last the longest.