On 21-11-2012 13:27, Roman Rokytskyy wrote:

>> will it re-create and re-prepare update statement on every call to update the row ? or will it be able to cache one prepared update statement and only subsistute new parameters during the whole loop ?
>
> Former - on each row application might update different rows and we want
> to change only them. So the update statement is re-prepared each time.

Looks like something that could be improved by only re-preparing if the
statement is different.

Mark
--
Mark Rotteveel