bug #6484: Include all paramaters of FindOccurrencesConfigurator in HQL query - EDIT - EDIT Project Management

Actions

Copy link

bug #6484

open

Include all paramaters of FindOccurrencesConfigurator in HQL query

Added by Patrick Plitzner over 6 years ago. Updated over 2 years ago.

Status:

New

Priority:

Highest

Assignee:

Andreas Müller

Category:

cdmlib

Target version:

Release 5.44

Start date:

Due date:

% Done:

20%

Estimated time:

Severity:

normal

Found in Version:

Tags:

performance pp_uebergabe

Description

Currently AssignmentStatus and isRetrieveIndirectlyAssociatedSpecimens() are not queried via HQL but in the service method via a for loop. This is very time consuming and also does not allow to use these parameters in the countOccurrences() method.

Actions

Copy link

Updated by Andreas Müller over 6 years ago

Target version changed from Release 4.7 to Release 4.8

Actions

Copy link

Updated by Andreas Müller about 6 years ago

Target version changed from Release 4.8 to Release 4.9

Actions

Copy link

Updated by Andreas Müller about 6 years ago

Target version changed from Release 4.9 to Release 4.10

Actions

Copy link

Updated by Andreas Müller almost 6 years ago

Target version changed from Release 4.10 to Release 4.11

Actions

Copy link

Updated by Andreas Müller almost 6 years ago

Target version changed from Release 4.11 to Release 4.12

Actions

Copy link

Updated by Andreas Müller almost 6 years ago

Target version changed from Release 4.12 to Release 4.13

Actions

Copy link

Updated by Andreas Müller over 5 years ago

Target version changed from Release 4.13 to Release 4.14

Actions

Copy link

Updated by Andreas Müller over 5 years ago

Target version changed from Release 4.14 to Release 5.0

Actions

Copy link

Updated by Patrick Plitzner over 5 years ago

Priority changed from Highest to Priority12
Target version changed from Release 5.0 to Reviewed Next Major Release
% Done changed from 0 to 20

Actions

Copy link

#10

Updated by Andreas Müller over 4 years ago

Priority changed from Priority12 to Priority11

Actions

Copy link

#11

Updated by Andreas Müller almost 4 years ago

Tags set to pp_uebergabe
Target version changed from Reviewed Next Major Release to 287

Can you give some more information about context (specimen tree, matrix, dataportal, ...?) and other information required to solve the ticket.

Actions

Copy link

#12

Updated by Patrick Plitzner almost 4 years ago

Assignee changed from Patrick Plitzner to Andreas Müller

This configurator is used in a lot of places: specimen tree editor, specimen facet search (experimental), TaxonService, SpecimenImport, ...(results from string search of the workspace)

The service method to look for is OccurrenceServiceImpl.findByTitle()

The two mentioned options AssignmentStatus and indirectlyAssociatedSpecimen are currently evaluated in an extra loop in OccurrenceServiceImpl.filterOccurencesByAssignmentAndHierarchy(), which could maybe be integrated into the database query. This is especially bad for the countByTitle() method which currently loads the objects because of that instead of just retrieving the count from the DB.

AssignmentStatus: enum to define whether the specimen have an association to a taxon or not
indirectlyAssociatedSpecimen: if true the complete derivative hierarchy including all parent and child derivatives is returned of the associated specimen

Actions

Copy link

#13