|Subject||Re: AW: [Firebird-Java] jabird / Select / Update|
>> 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 ?Sorry, I meant "different columns".
> 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.
So, if the columns that will be updated is known, it is better to use a