On Tue, Apr 10, 2012 at 5:05 PM, Andrea Aime <[email protected]> wrote: > > Il giorno 10/apr/2012 02:56, "cmaul" <[email protected]> ha > scritto: > > >> 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? > > Geoserver does two queries, one to determine how many features are in the > pixel you queried and one to determine the actual features. Normally that is > pretty fast since the area queried is so small, I guess either the SDE > connector is missing some optimization or the underlying database is missing > either a spatial index or has outdates statistics and it is not using the > index. Hard to tellwithout access to the actual data.
The ArcSDE connector can't do optimized count on ArcSDE + Oracle _only_ if the table is registered as versioned in ArcSDE. The proprietary arcsde jar produces an error if you try to compute table statistics on versioned tables. That said, by looking at the code [1] it looks to me like there's actually a bug in there. I think the query scan should only be done if that's the case, but the control statement is not enclosing it. But I am not sure, would need to re-test it and document what's the actual behavior with oracle. Can't do that right now though due to other priorities. Chances are you create a jira issue and assign it to me so I don't forget, or if you have some coding skills you can send a patch. Cheers, Gabriel [1] <https://github.com/geotools/geotools/blob/2.7.x/modules/plugin/arcsde/datastore/src/main/java/org/geotools/arcsde/data/ArcSDEQuery.java#L613> > > Cheers > Andrea > >> >> 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 > > > ------------------------------------------------------------------------------ > 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 > -- Gabriel Roldan OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ 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
