Re: JDBC Batch


stephane
 

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

Join main@datanucleus.groups.io to automatically receive all group messages.