Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
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

Replies are listed 'Best First'.
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?
[LanX]: still can't believe this, must h have been a misunderstanding
[choroba]: fortunately, I haven't the need to verify this
[choroba]: haven't had
[choroba]: but most tourist here are form the US, France, and Russia
[Your Mother]: The best whiskey in Thailand is Vietnamese, is all I know.

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2017-02-26 04:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (371 votes). Check out past polls.