Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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 musing on the Monastery: (7)
As of 2014-10-22 00:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (112 votes), past polls