SQLITE - Update multiple columns, in multiple rows on a table with a composite PK
Finding each row to update requires an index lookup. Writing a combined query would not change this.
Minimize the transaction overhead by running all UPDATEs inside a single transaction. Further performance improvements are not possible.