WMS GetFeatureInfo operation using Oracle Data Store with large number of items in table fails
----------------------------------------------------------------------------------------------
Key: GEOS-1896
URL: http://jira.codehaus.org/browse/GEOS-1896
Project: GeoServer
Issue Type: Bug
Components: Oracle, WMS
Environment: Oracle 11.1.0.0.0
Geoserver 1.6.3
Reporter: Bruce E. Thelen
Assignee: Andrea Aime
I have an Oracle table with approximately 90M rather simple polygons in it.
I have a feature type created in Geoserver which responds to WMS GetImage requests and can draw these polygons with no problem. I had to enter the bounding box into the UI myself to create the feature type, as the generate would not work for the same reason the GetFeatureInfo does not work.
When I attempt a GetFeatureInfo call to WMS, the request takes too long and the browser times out. Geoserver is trying to calculate the bounding box for all the feature types I have configured. In calculating this bounding box, it is calling SDO_AGGR_MBR against the table with 90M polygons which will not return for several hours.
WFS GetCapabilities calls work very quickly and are evidently not subject to Geoserver recalculating a bounding box.
If this is not possible to accomplish due to whatever reason, I would gladly accept any workarounds you would like to suggest.
--
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