Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: difference between syb_nsql and prepare/execute call

by elwarren (Curate)
on Nov 09, 2010 at 16:57 UTC ( #870348=note: print w/ replies, xml ) Need Help??


in reply to difference between syb_nsql and prepare/execute call

If you prepare() then execute(), you have the option of executing the same statement multiple times without preparing again. A simple optimization that can add up when updating many records.

The syb_nsql combines these steps into one, as well as offering additional functionality with callbacks. Docs cover this better than I can explain it.


Comment on Re: difference between syb_nsql and prepare/execute call
Re^2: difference between syb_nsql and prepare/execute call
by perl@1983 (Sexton) on Nov 09, 2010 at 17:07 UTC
    I already checked the documentation at cpan, but could not understand clearly. So, do you mean to say that syb_nsql is better?
      I don't know about you, but I read that as saying there are trade-offs.
        So, which one would you prefer? syb_nsql or prepare/execute?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (13)
As of 2014-12-18 08:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (44 votes), past polls