Use Case:
Some user accidentally created test data and now wants to get rid of the same
Tips to perform large bulk imports
One should perform these import during non-peak hours or off time i.e when no others users are using the application. User can even enable the 'System Lockdown' feature to keep other users from logging into the system.
The database locks the tables from which the data is being deleted. Run the import in non-atomic mode which means set the pre-validate to a small number 100 or 200, which will ensure the locks are not held by any one transaction for a long time.
Deleting participants, visits or specimens which have too much dependent data can take time.