On 8 May 2015, at 11:40pm, Scott Doctor <scott at scottdoctor.com> wrote:
> 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. Yep. There's nothing stopping you from doing that. But if the changes you make would modify the result of SELECTs which are still running, you may find it difficult to predict how they would interact. Simon.
