Hi Sommer, some responses inline On Tuesday 23 May 2006 00:09, Chris Holmes wrote: > Saul and Gabriel are the ArcSDE experts, so they can probably give you a > bit more information. It doesn't surprise me that PostGIS is faster, > but I don't think it should be 16 times as fast. Afaik Filtering in > ArcSDE should be done on the server side, not purely in geotools, so it > should be a bit faster. > > Chris > > Sommer Gerhard wrote: > > 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. so bad. I _should_ be fast. Never compared performance against postgis, but definately is shouldn't be 16 times slower. There are couple things that could be going wrong though, and I would need a bit more information to able of making a diagnostic.
Could you tell me what version of GeoServer are you trying, what version of ArcSDE, over which RDBMS and operating system? > > > > 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)? Well, that could be a good indication that for some reason the filter is not being executed on the server (which shouldn't be happening). From the top of my head I can think that another problem could be related to how the featuretype were set up on arcsde, it could be a bad performing spatial index or even an inexistent one. How did you set this up? how many features are in your table, and what's the nature of them? (geometry type, avg number of points, etc) I guess you can obtain this information from an "sdelayer -o describe_long " command, it would be very useful if you can send us the output of that command. > > > > Also the number of features returned differ by two (586 returned from > > PostGIS and 588 from ArcSDE). hmm.. this could be just that we're treating bbox filtering a bit differently. (heck we really need good set of datastore conformance tests) Would you be able of raising a jira issue about this? Thanks for reporting back, looking forward to help you. Gabriel > > > > 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 -- Gabriel Roldán ([EMAIL PROTECTED]) Axios Engineering (http://www.axios.es) Tel. +34 944 41 63 84 Fax. +34 944 41 64 90 ------------------------------------------------------- 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
