Hi
I've got performance issues when filtering on two different properties
in my SLD. Filtering using one property works fine.
This filter statement works fine:
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>OBJ</ogc:PropertyName>
<ogc:Literal>300</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
When I add another property to the filter it gets really slow:
<ogc:Filter>
<ogc:And>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>OBJ</ogc:PropertyName>
<ogc:Literal>300</ogc:Literal>
</ogc:PropertyIsEqualTo>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>TYP</ogc:PropertyName>
<ogc:Literal>3000</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:And>
</ogc:Filter>
My data is stored in Oracle 11.2. I have rebuilt the indexes on the
columns OBJ and TYP and even my geometry column.
Any good suggestions on why it gets so much slower when adding the
second property?
Is there a way to put a filter directly on the layer/feature type? I
don't know how Geoserver manages WFS-requests on a layer, but I hope it
uses the SLD-filtering. Otherwise it would be really necessary to have a
filtering option for the layer too.
Regards
Anders Erlandsson
------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
