Re: [Geoserver-users] Parametric view (Oracle) layeris very slow even though the query is fast

2012-05-16 Thread Andrea Aime
On Tue, May 15, 2012 at 9:05 PM, cheesybiscuits thomaschrist...@gmail.com wrote: I have a layer defined in GeoServer which uses a parametric view to Oracle (11.2.0.1, with Locator capabilities). The query I use to define the view is not particularly complex and when I run it directly against

[Geoserver-users] Parametric view (Oracle) layeris very slow even though the query is fast

2012-05-15 Thread cheesybiscuits
I have a layer defined in GeoServer which uses a parametric view to Oracle (11.2.0.1, with Locator capabilities). The query I use to define the view is not particularly complex and when I run it directly against the DB it executes in well under 1 second. If I request a WMS map from this layer