Extract strings directly from the ResultSet instead of using getObject()
------------------------------------------------------------------------
Key: GEOT-2250
URL: http://jira.codehaus.org/browse/GEOT-2250
Project: GeoTools
Issue Type: Improvement
Components: data jdbc-ng
Affects Versions: 2.5.2
Reporter: Andrea Aime
Fix For: 2.5.3
Looking into why a non ps version of the postgis-ng datastore was 20+% slower
than the old one I noticed that a good part of the slowdown was due to usage of
getObject() in the FID building code.
Comparing with the old datastore I noticed that the old one was using
getString() instead.
This makes sense, as the FID is string based anyways. The new code was
triggering a metadata lookup to determine the type of the column, a parsing
from string to int (since the pk was integer, but the pg driver transfer data
in text format), only to turn that into a string again.
--
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
------------------------------------------------------------------------------
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
