WFS performance issue

Frank Warmerdam fwarmerdam at GMAIL.COM
Thu Mar 24 10:56:07 EST 2005


On Thu, 24 Mar 2005 10:24:39 -0500, Yewondwossen Assefa
<assefa at dmsolutions.ca> wrote:
>    I understand the this way of implementing complexe filters is not the
> most optimal but Filters can become so complex that I need some kind of
> logic and limitation to be able to adress all the cases.

Assefa,

As I understand it, we only have the opportunity for one SQL query
to be evaluated in the RDBMS via the FILTER operator on a layer.
What I would suggest is that if you find the query to be simple -
that is a single bbox and/or one set of simple property operations then
you convert the attribute queries into a  FILTER and let the underlying
provider take care of it.

In all other circumsances just fallback to the existing approach
which we have confidence works for complex cases.  So we would
basically just optimize simplier queries.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent



More information about the mapserver-dev mailing list