Should I file this in JIRA as a regression?
Simon
From: Simon Hartley [mailto:[email protected]]
Sent: 12 July 2016 17:36
To: [email protected]
Subject: [EXTERNAL][Geoserver-users] GeoServer upgrade issue from 2.2.5
I have a WMS layer using a Rendering Transformation for a parameterized SQL
View layer (which calls a database function).
Upgrading from an old version of GeoServer we've experienced a massive
performance problem with this layer.
When setting logging to verbose, the old version produced SQL something like:
SELECT encode(ST_AsBinary(ST_Force_2D("location")),'base64') as
"location","myval" FROM (select location, thevalue as myval
from myschema.get_data( 70,50 )) as "vtable" WHERE "location" &&
ST_GeomFromText('POLYGON ((-26.823634473210518 6.409727748826477,
-26.823634473210518 33.560993640777525, 0.3276314187394202 33.560993640777525,
0.3276314187394202 6.409727748826477, -26.823634473210518 6.409727748826477))',
4326)
The new version shows:
SELECT encode(ST_AsEWKB("location"),'base64') as "location","myval" FROM
(select location, thevalue as myval from myschema.get_data( 70,50 )) as "vtable"
The lack of spatial filter causes a huge performance problem since about 100
times as many rows are returned and the Barnes Surface transformation gobbles
up all the CPU and GeoServer becomes unresponsive.
Any thoughts about what could be causing the spatial filter to no longer be
added?
What I've read in other threads hasn't really made this clear to me.
Thanks,
Simon Hartley
.
*** This communication has been sent from World Fuel Services
Corporation or its subsidiaries or its affiliates for the intended recipient
only and may contain proprietary, confidential or privileged information.
If you are not the intended recipient, any review, disclosure, copying,
use, or distribution of the information included in this communication
and any attachments is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
communication and delete the communication, including any
attachments, from your computer. Electronic communications sent to or
from World Fuel Services Corporation or its subsidiaries or its affiliates
may be monitored for quality assurance and compliance purposes.***
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
