There are a number of areas that make excessive database calls. One of these areas is during Advanced Normalisation. This can be seen by turning on the show_sql hibernate option.
I have begun changes to fix this issue. I have changed a section in HibernateDataObjectDAO.deleteXenaProcessingRecord that was resulting in excessive select calls. These changes are on the performance branch. The next section of code in this function looks like it could also be improved. This section updates and saves PFDataObjectProcessingRecords one at a time. Changing it to use a bulk update should improve performance. Assigned to Margot to decide whether to include these changes in the next release or not. This change could also be cut down to just what I have done so far for release if desired.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have begun changes to fix this issue. I have changed a section in HibernateDataObjectDAO.deleteXenaProcessingRecord that was resulting in excessive select calls. These changes are on the performance branch. The next section of code in this function looks like it could also be improved. This section updates and saves PFDataObjectProcessingRecords one at a time. Changing it to use a bulk update should improve performance. Assigned to Margot to decide whether to include these changes in the next release or not. This change could also be cut down to just what I have done so far for release if desired.