Hi, I'm working with a faily large oracle spatial table (1 500 000 polygons).
I need to perform a WPS aggregate using a intersecting polygon so I chained a gs:clip with gs:aggregate. I just noticed that Geoserver retrieves all the features from the DB to perform the spatial operation which is very slow. What would be the best way to filter the data spatially using Oracle first and then perform the aggregate with WPS ? There must be a way of sending a WFS request with a polygon and pass the intersecting polygons returned by oracle to the aggregate function. I tried using RectangularClip but it also retrieves all the data. Thanks -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
