Hi, I tried out GeoServer, which uses GeoTools, to fetch selected features (WFS-Request using BBOX filter)from PostGIS and ArcSDE.
PostGIS is fast, but ArcSDE takes as long as for fetching all the features in the feature type (16 times longer). It looks like the ArcSDE data store fetches all the features and the spatial selection is done by GeoTools. Can anyone tell me, if I am right in my assumption, and if not, what is the reason for this performance difference (fetching all the features takes the same time with PostGIS and ArcSDE)? Also the number of features returned differ by two (586 returned from PostGIS and 588 from ArcSDE). Best Regards, Gerhard -- Gerhard Sommer Magistrat Wien (MA 14-ADV), Rathausstraße 1, 1082 Wien, Austria E-Mail: [EMAIL PROTECTED] Tel: +43 (1) 4000 91326 Fax: +43 (1) 4000 99 91326 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
