I can give you an example:
To create a planning in pharma the user input information regarding to that batch and it will create automatically a sequence of process and a sequence of sampling stage and a list of tests required. To automate the planning different “master” tables are being used to create the link between each layer.
In just one click the planning can be created but we need loops to create records to track the info in specific linked table (ex of layers : one table to track batch, one to track by process stage, one by sampling stage, one by sample, one by tests)
And I encounter the sample problem to change status (especially of linked record). For example when a sample is ready at the lab the status of all the tests related to this sample should change to ready. At the moment I call these records with the table API and I do a loop to change the status of each.
I believe the mass update feature in coming could help (yet not sure of what it could achieve exactly) but in the meantime increasing the limit of triggers will do.