Hi,
We have a web application showing sewerage data using geoserver 2.1.1 and
OpenLayers 2.11. Some of our users should be restricted to a city or some other
region.
We created a proxy before geoserver which accepts all requests made by
OpenLayers. Based on the user a CQL_FILTER ("within(the_geom,
geometry_of_city") is added to the request. But we noticed this being very slow
for restricted users when making a GetMap request, because it appears geoserver
first executes the CQL_FILTER and then checks for every hit if this feature is
in the bbox. To limit the number of records returned by the CQL_FILTER we make
an intersection of the geometry_of_city and the bbox of the request, this
resulting geometry is used as the CQL_FLTER. This gives better performance, but
is still slower than a normal user (because every feature is still validated
against the bbox, which is unnecessary because it's already been taken care of).
Is there any possibility to change this behavior (removing the bbox-parameter
from the request is not an option, because that's a required parameter for a
GetMap request)? Or maybe another approach to implement this functionality?
Kind regards,
Roel
________________________________
Volg Aquafin op Facebook<https://www.facebook.com/AquafinNV> |
Twitter<https://twitter.com/aquafinnv> |
YouTube<http://www.youtube.com/channel/UCk_4P5BJ-MtEEDCkCsR_KqQ?feature=mhee> |
LinkedIN<http://www.linkedin.com/company/aquafin/products>
Disclaimer: zie www.aquafin.be<http://www.aquafin.be> P Denk aan het milieu.
Druk deze mail niet onnodig af.
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
