Re: difference between syb_nsql and prepare/execute call

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?	[reply]
Re^3: difference between syb_nsql and prepare/execute call by Anonymous Monk on Nov 09, 2010 at 17:52 UTC
I don't know about you, but I read that as saying there are trade-offs.	[reply]
Re^4: difference between syb_nsql and prepare/execute call by perl@1983 (Sexton) on Nov 09, 2010 at 18:55 UTC
So, which one would you prefer? syb_nsql or prepare/execute?	[reply]
Re^5: difference between syb_nsql and prepare/execute call by Anonymous Monk on Nov 09, 2010 at 21:05 UTC
Re^5: difference between syb_nsql and prepare/execute call by elwarren (Priest) on Nov 10, 2010 at 14:13 UTC

In Section Seekers of Perl Wisdom