Speed up grabbing column meta info for vitrual tables
-----------------------------------------------------
Key: GEOT-3349
URL: http://jira.codehaus.org/browse/GEOT-3349
Project: GeoTools
Issue Type: Improvement
Components: data jdbc-ng
Affects Versions: 2.7-beta1
Reporter: Christian Mueller
Assignee: Andrea Aime
Attachments: metainfo.patch
If a db does not support limit/offset, grabbing the column meta data may last
very long for queries over large tables. In my current setup, the process needs
about 10 - 30 secs.
The logic is in the static method getColumnMetaData in class JDBCFeatureSource.
I checked an alternate idea, independent of limit/offset support.
select * from ( <vtable select statement> ) where 1 = 0
Works fine and is fast.
Attached a patch for trunk.
@Andrea, if you like I could reassign to me and apply the patch.
--
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
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
