Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^4: difference between syb_nsql and prepare/execute call

by perl@1983 (Sexton)
on Nov 09, 2010 at 18:55 UTC ( #870378=note: print w/ replies, xml ) Need Help??


in reply to Re^3: difference between syb_nsql and prepare/execute call
in thread difference between syb_nsql and prepare/execute call

So, which one would you prefer? syb_nsql or prepare/execute?


Comment on Re^4: difference between syb_nsql and prepare/execute call
Re^5: difference between syb_nsql and prepare/execute call
by Anonymous Monk on Nov 09, 2010 at 21:05 UTC
    Generally, the programs I'm asked to write use a handful of known SQL statements called several times with varying bound parameters. In those situations, prepare/execute has definite speed advantages.

    If you're only going to use a statement once during the life of the program (or connection), those advantages fade away. In that case there can be advantage, or at least convenience, in an all-in-one statement.

    So without knowing your particular use case, I'm sorry to say I can't make your decision for you.

Re^5: difference between syb_nsql and prepare/execute call
by elwarren (Curate) on Nov 10, 2010 at 14:13 UTC

    I use DBD::Oracle for most of my work, so I prefer prepare/execute ;-)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (12)
As of 2015-07-02 22:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (46 votes), past polls