I am working at the Department of Sustainability and Environment Victoria, Australia and we recently switched with some applications from esri to geoserver2.1.3. (to be precise: Geoserver2.1.3/Tomcat6.0.35/Java1.6.31/Apache2.2.24/Windows2008 64-bit) The WMS works fine (getMap) but there are problems with the getFeatureInfo.
The SDE version is 9.2, we have a trial version of 9.3.1 both on top of Oracle 10g and both display the following behaviour: tables with small amount of features (100 - 5000) return a getFeatureInfo in less than 500msec. tables with up to 50000 features need 10 seconds at 200000 features the getFeatureInfo needs 30 - 60 seconds. With 3 mio features 9.2 does not return a response using the jsde-sdk92.jar, using the jsde-sdk93.jar it returned a response after 70 minutes. Unfortunately there are 3 million land parcels in Victoria. Converting the data to Oracle Locator format showed that the response comes within 1 second. Analyses (Oracle traces) have shown that the getFeatureInfo with ArcSDE causes a full table scan. That seems to me to be at the core of the problem of these long response times. Is there any way to avoid that and to get ArcSDE to behave like a database i.e. that is to use an index? There is also a completely absurd behaviour with views. A view containing the parcel table above and additional non-spatial fields returns getFeatureInfo information in an instant until you start to pan or zoom a 5-6 times and then it does the full table scan as again. Why is that so? Cheers Christian ----- ____________________________ Dr Christian Maul Project Manager Information Services Branch Department of Sustainability and Environment Level13, Marland House, 570 Bourke Street Melbourne 3000 PO Box 500, East Melbourne Vic 3002 Telephone: +61-3-8636 2325 Telefax: +61-3-8636 2813 -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ArcSDE-database-geoserver-WMS-getFeatureInfo-request-tp4722371p4722371.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
