Blog Post
.. Once the brain trust is finished with the Robustness and scalability and reliability of Automations, someone should look at why deleting records is so slow. In my apps they delete at about 1.5 records per second. That's like watching paint dry when you have even 100 records to delete and confused users which are seeing child records on a Parent form. The limit for deleting records is 1,000, but I doubt that you can even delete 1,000 records as the Automation would time out. (11 minutes @ 1.5 deleted records per second)
A typical use case can be that you have a process which auto creates say children based on running a saved Table to table import and for some reason those need to be refreshed and re-imported. As it stands now, the purge process which would be the first step in the Automation is impractical if there are going to be more than a small handful of records to delete.
We love Automations, and I'm happier to have delete ability than to not have it at all, just want it on the list to be improved for throughput.
A typical use case can be that you have a process which auto creates say children based on running a saved Table to table import and for some reason those need to be refreshed and re-imported. As it stands now, the purge process which would be the first step in the Automation is impractical if there are going to be more than a small handful of records to delete.
We love Automations, and I'm happier to have delete ability than to not have it at all, just want it on the list to be improved for throughput.