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 (providing the same parameters as when I execute the query directly) it takes around 10 seconds to render. I am using extremely simple styles at the moment (red squares for all points). My first thoughts are that this is something to do with my query being used as a subquery by GeoServer, and that this might impact on the use of the spatial index of the underlying table. Has anybody had similar experiences, and maybe can offer some advice? I am using a JNDI connection but previously saw similar behaviour under the regular ng connection type. My next step is to start profiling the queries but I'm hoping somebody might have good advice first. Thanks -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Parametric-view-Oracle-layeris-very-slow-even-though-the-query-is-fast-tp4974842.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users