DBI prepare_cached

[hok_si_la]

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

[runrig]

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.

[hok_si_la]

runrig,

Thanks for the quick response.

hok_si_la

[Codon]

I so mis-read that reply. Never mind.