> 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.

Roman