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.
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
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org
begin:vcard
fn:Chris Holmes
n:Holmes;Chris
org:The Open Planning Project
adr:;;377 Broadway, 11th Floor;New York;NY;10013;USA
email;internet:[EMAIL PROTECTED]
title:VP, Strategic Development
x-mozilla-html:FALSE
url:http://topp.openplans.org
version:2.1
end:vcard
