Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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)

Replies are listed 'Best First'.
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 contemplating the Monastery: (6)
As of 2016-10-01 20:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?






    Results (7 votes). Check out past polls.