Improve epsg-hsql access performance
------------------------------------
Key: GEOT-1129
URL: http://jira.codehaus.org/browse/GEOT-1129
Project: GeoTools
Issue Type: Improvement
Components: core referencing
Affects Versions: 2.3.0
Reporter: Andrea Aime
Assigned To: Martin Desruisseaux
Getting a list of all CRS codes in the EPSG authority against the epsg-hsql
authority is very slow.
A simple loop like:
Set codes = CRS.getSupportedCodes("EPSG");
for (Iterator it = codes.iterator(); it.hasNext();) {
String code = (String) it.next();
CoordinateReferenceSystem crs = CRS.decode("EPSG:" + code);
}
takes 23 seconds on my PC.
I have patches to take that time down to 2 seconds.
The first one is just a couple of new indexes in the hsql script, the second
one is about turning a join into a subselect.
I would like a review to the second one before committing it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
