Hello @qdmt ,
regarding the speed improvement, did you create an index for the columns you select in the DB Merge node as identification columns? If not the database will do a full table scan for each row you process which might take ages depending on the size of the database table you want to update.
If the columns are unique, which I guess is the case, you can create a unique index via the “Keys” tab of the DB Table Creator node where you can create a primary or unique key.
Bye
Tobias
2 Likes