DBI prepare

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

Comment on DBI prepare_cached

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]
Re^2: DBI prepare_cached by hok_si_la (Curate) on Sep 08, 2005 at 21:32 UTC
runrig, Thanks for the quick response. hok_si_la	[reply]
Re^2: DBI prepare_cached by Codon (Friar) on Sep 08, 2005 at 21:42 UTC
I so mis-read that reply. Never mind. Ivan Heffner Sr. Software Engineer, DAS Lead WhitePages.com, Inc.	[reply]