Update with two table ,I had a example for one row,but I must update 168432 rows,used sqlite

I want to update the sqlite table, the following is the example for updating one row:

update tpecroad set tnode = (SELECT  b.nodeid FROM "TPECRoad" as a
join tpecnode as b 
where pointn(a.geometry,numpoints(a.geometry)) = b.geometry and a.pk =1)
where pk=1

but there are 168432 rows to be updated, is there any faster way to update the large amount of the data?

It's like changed a.pk=1~168432 and pk=1~168432

Thanks a lots!!