How to mass update product attribute efficiently?

Hello, as a junior developer I am creating a data patch to append a string to a text attribute of tens of thousands products.

I want to do it by updating attribute table by each row of the attribute using connection resource in a loop. But I am not sure if it will not overload the server. Is there a better way to do that?