[SIS-335] CRS.findOperation(…) sometime slow

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7
• Fix Version/s: 0.8
• Component/s: Referencing
• Assignee: Martin Desruisseaux
• Reporter: Martin Desruisseaux
• Created: 04/Nov/16 19:05
• Updated: 02/May/17 12:28
• Resolved: 04/Nov/16 19:06

Description

Execution of CRS.findOperation(sourceCRS, targetCRS, areaOfInterest) is slow when:

• A connection to the EPSG geodetic dataset is available (which is recommended)
• the given CRS have no EPSG identifiers, or their identifiers are wrong

In such case, IdentifiedObjectFinder search the right EPSG code for the given CRS by scanning the EPSG database. Some conditions are put in the SQL WHERE clause for reducing the amount of CRS to scan, but in Apache SIS 0.7 those conditions are not restrictive enough, resulting in way too many CRS being scanned.