So if I have a loop that finds a row with some data (statement1) then based on values from that row sets fields in other rows statement2 find a row to set new data statement3 set column to something, repeat n times. then go back and do it all again x times. I can prepare the 3 statements first then loop until I am done then finalize the 3 statements. That sure saves much overhead from preparing and finalizing 3*n*x times.
------------ Scott Doctor scott at scottdoctor.com ------------------ On 5/8/2015 3:20 PM, Richard Hipp wrote: > On 5/8/15, Scott Doctor <scott at scottdoctor.com> wrote: >> Can I prepare multiple statements then implement them in >> arbitrary order (based on some logic)? >> >> Or do the statements need to be prepared, stepped, finalized >> serially? >> > They can be run in any arbitrary order. That is the usual case, actually.
