I would like to update multiple rows from a different table, should i just increment a column? is that the best way to do it with API? is updating everything on the table the same as updating 1 row, sync wise?
Maybe you’re asking about a technique that is sometimes called a quick update system? That’s certainly a valid approach for triggering recalculation of one or more rows.
It’s certainly possible to do that via API. Consider also using instead a combination of data actions like execute on a set of rows and update column values in a row.
The more rows being recalculated, the longer it takes to do so, and the longer it takes to sync the updates between the cloud and a user’s device.
If your scenario entails updating rows with new values that don’t trigger recalculation of other columns, that’s typically faster.