Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^4: perl dbi, prepare function using place holder

by chacham (Prior)
on Aug 26, 2016 at 20:16 UTC ( [id://1170557]=note: print w/replies, xml ) Need Help??


in reply to Re^3: perl dbi, prepare function using place holder
in thread perl dbi, prepare function using place holder

Well, that is sort of true. SQL Server has bind variable peeking which can change the plan. And Oracle recently introduced changing plans while a statement is running. Regardless, the gist of what you wrote is true. Part of the purpose of the preparation is to generate a (somewhat generic) query plan, which does not change very often.

Other reasons include, query rewrite only engages once and a handle can be passed for each executions used instead of a statement since the same statement is reused.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (6)
As of 2024-03-29 13:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found