Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Tricks with DBI

by runrig (Abbot)
on Oct 19, 2001 at 02:10 UTC ( #119818=note: print w/ replies, xml ) Need Help??


in reply to Tricks with DBI

my($id, $name, $phone); $sth->bind_columns(undef, \$id, \$name, \$phone);
A shorter way is:
$sth->bind_columns(\my ($id, $name, $phone));
And regarding this statement:

And, for the same reasons, you should use prepare_cached instead of prepare.

Choosing prepare or prepare_cached really depends. The caching is a slight overhead, so if I can reasonably arrange my SQL so that something is only prepared once (or if its used just once anyway), then I'll just use 'prepare'. Or if you're dynamically creating a SQL statement (lets say a million times) and the number of possible unique combinations is large, then you don't want to use prepare_cached, e.g. you have a couple of 'IN' clauses, and each one might have 1-100 elements, so you end up with something like:

select stuff from table where field1 in (?,?,?,?) and field2 in (?,?,?,?,?)
(Note: placeholders are still a good idea in this case)


Comment on Re: Tricks with DBI
Select or Download Code
Re: Re: Tricks with DBI
by princepawn (Parson) on Oct 19, 2001 at 03:44 UTC
    And, for the same reasons, you should use prepare_cached instead of prepare.
    Never prepare_cached() ping calls, because you will get true each time instead of actual ping results.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://119818]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2015-07-04 19:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls