Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
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 avoiding work at the Monastery: (8)
As of 2015-07-05 20:18 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 (68 votes), past polls