[ALOY-1136] SQL sync adapter: add method or optimize query for bulk-updates
| GitHub Issue | n/a | 
|---|---|
| Type | Improvement | 
| Priority | Medium | 
| Status | Open | 
| Resolution | Unresolved | 
| Affected Version/s | n/a | 
| Fix Version/s | n/a | 
| Components | Models | 
| Labels | n/a | 
| Reporter | Tim Poulsen | 
| Assignee | Unknown | 
| Created | 2014-09-12T15:38:03.000+0000 | 
| Updated | 2018-03-07T22:25:37.000+0000 | 
Description
	The SQL sync adapter's create/update method is currently best-suited to updating a single model at a time. The query could be optimized, or a separate method could be added to make bulk updates (multiple models in a single operation) so that such changes could be done in a more performant method.
Options might include 
- update REPLACE INTO query to pass multiple VALUES
- execute multiple queries, but wrap in transaction so that there's a single atomic operation on the DB
A transaction should be used in either case to provide recovery in the case of an error during the update.
No comments