Question: what is the difference between delete and purge?
Answer: Delete removes the rows on going. For example, if you have a work queue, and the tasks will be finished after the queue, you can delete those rows since they are not needed anymore. Purging is the process of freeing up space in the database or of deleting obsolete data that is not required by the system.