Re: Mix betwenn storage procedures and transactions

[Rick James]

What you have done (START+COMMIT) is no different than using autocommit.

Your UPDATEs are hitting every row? How big are the tables?

What does fn_update() do?

I am fishing for whether this Procedure is destined to take a long time (lots of rows + slow function), or whether some optimization/simplification can be made.

If it turns out that you need to do the UPDATEs piecemeal, see this for a discussion of chunking the action (it talks about DELETE, but can be adapted to UPDATE): http://mysql.rjweb.org/doc.php/deletebig