Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

DBI prepare_cached

by hok_si_la (Curate)
on Sep 08, 2005 at 21:08 UTC ( [id://490323]=perlquestion: print w/replies, xml ) Need Help??

hok_si_la has asked for the wisdom of the Perl Monks concerning the following question:

Greetings Monks,

I use use DBI to execute my MS SQL server statements. I recently read Here that the method prepare_cached stores the statement handle in a hash associated with $dbh. What is the scope of that hash? Is it useless to use prepare_cached when a statement handle is not executed more than once within a given subroutine?

Thanks for your help
hok_si_la

Replies are listed 'Best First'.
Re: DBI prepare_cached
by runrig (Abbot) on Sep 08, 2005 at 21:23 UTC
    What is the scope of that hash? Is it useless to use prepare_cached when a statement handle is not executed more than once within a given subroutine?
    The same as the $dbh. If a given statement is only executed prepared once on the same database handle, then prepared_cached is useless.
[reply]
      runrig,

      Thanks for the quick response.

      hok_si_la
[reply]
      I so mis-read that reply. Never mind.

      Ivan Heffner
      Sr. Software Engineer, DAS Lead
      WhitePages.com, Inc.
[reply]

Back to Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: perlquestion [id://490323]
Approved by gam3
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others scrutinizing the Monastery: (1)
As of 2024-04-25 04:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found