Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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

Replies are listed 'Best First'.
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?
[TStanley]: I'm sitting in the airport in Tampa, Florida at the moment, getting ready to head home.
[talexb]: TStanley I'm flying to Vegas in two weeks time. After that flights leaving Vegas and Phoenix are late at night .. I've been hearing that it gets so hot that the air isn't dense enough for planes to take off. Weird. Guess you won't have that problem.

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (10)
As of 2017-06-23 14:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (548 votes). Check out past polls.