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.
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
