Delete All Time Issues: Important Information about the Delete All process when deleting over 200 records at once
It is critical that all users who regularly delete a lot of variables at once understand the deletion process:
When each record is deleted a number of steps are completed:
- The server loads each individual record in it's entirety; each field, calculation, historical calculation, linked profile field, linked data field, and any filters on each field are all loaded on the server.
- It checks that the person deleting the record has access to delete the record (e.g. the Delete All module and delete permissions for the Event Form)
- Then it checks that you have access to each user that you are deleting the record for, through the Groups and SubGroups
- It then creates a NEW record and inserts it into your system as a "Deletion Revision". This Deletion Revision is stored on the server so that there is a back up incase the deletion is accidental and has to be reversed. It also informs us who deleted the record and when.
- Then the software removes the record from the system for anyone with access to it.
Therefore, the time taken to do all of these steps is dependent on the number of fields in the form and number of records that are selected to delete. The more the Event form fields and athletes, the longer the process.
Moreover, a timeout error was occurring after 5 minutes of deleteion, and was causing issues for some users. This timeout error message is outlined below.
You can delete multiple records a once. However, this does take time depending on the size of the Form and the number of records
As mentioned above, the size of the Event Form, and the number of records that are being deleted affects the speed that this can be completed. For this example, 1000 records will be deleted at once.
When the Delete All button is clicked, the system has to go through and complete all of the deletion steps outlined above.