[Dpr-development] [ dpr-Bugs-3613492 ] Advanced Normalisation calls database excessively

[SourceForge.net <no...@so...>]

Bugs item #3613492, was opened at 2013-05-16 23:59
Message generated for change (Comment added) made by terryoneill
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=676456&aid=3613492&group_id=116934

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Preservation
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Terry O'Neill (terryoneill)
>Assigned to: margotc (margotc)
Summary: Advanced Normalisation calls database excessively

Initial Comment:
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.

----------------------------------------------------------------------

>Comment By: Terry O'Neill (terryoneill)
Date: 2013-05-17 00:08

Message:
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.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=676456&aid=3613492&group_id=116934