I mean when performing modifications, do something like:
-1 set constraints deffered => disable foreign-key, unique constraints, ...
-2 Batch updates table per table (addBatch, ...)
- perform all Deletes from table A if any
- perform all Inserts into table A if any
- perform all Updates of table A if any
- perform all Deletes from table B if any
- perform all Inserts into table B if any
- perform all Updates of table B if any
- ...
-3 commit
(Let the constraints are checked at the commit time.)
--
Stephane