My .02 worth…
I vote for slow but safe.
However, I guess it would be possible for system A in File 1 to set an address, then system B in File 2 to set the address for the same person to something else, and then system A in File 3 set the address for the same person.
In that case, it seems no matter how you process the data, it is possible to have the wrong result. Ideally you would want one system to be the system of ‘truth’ for certain data (say the person’s address) and ignore transactions for that data from other systems.
Jim Kosloskey
email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.