[mapserver-users] oraclespatial wfs issue

[Fernando Simon]

Hi Holger,
    I am not a WFS specialist (I'm including Bart as CC, he is the WFS
specialist), but I will try to help you.
    The maporaclespatial code try to use the extent that you define
for you map, but I believe that you can define the extent for you WFS
query (Am I right Bart?). So, the driver will use this extent as the
operator restriction.
     The anyinteract operator is used because we need to check all the
possibilities for interactions between the extent and the data
(touches, crosses, inside, one point...). The NONE token force the
driver to don't use any operator, so will not use the spatial index.
As hint, you can try the FILTER instead the RELATE, is more fast.
     Best regards.

Fernando Simon

porath at web.de wrote:
> Hi list,
>
> i am using mapserver 5.0.0 with oracle 10g as a wfs server. My
mapfile has one layer with the following DATA statement:
> DATA   "ha_koordinate from os_hako USING UNIQUE ha_id RELATE VERSION
10g"
>
> When i do a getFeature request using comparison operator (Like) the
sql produced by mapserver contains the spatial operator anyinteract
(with the EXTENT set in the mapfile which includes all 1.4M rows).
This is very inefficient, because it is not needed and slows down the
query from 0.5 to 10 seconds. Obviously, the function
osNoGeodeticData in maporaclespatial.c doesn't care if a spatial
operator is needed or not. The function seems to add it depending on
the configuration in the mapfile.
>
> When i change the DATA statement from "RELATE" to "NONE" the query
is very fast. But in this case queries containing spatial operators
(bbox) are slowing down from e.g. 1 second to 18 secods. So I am
caught between the Devil and the deep blue sea. 
>
> Any ideas?
>
> Thanks in advance.
>
> Holger
>
>
_____________________________________________________________________
> Unbegrenzter Speicherplatz für Ihr E-Mail Postfach? Jetzt
aktivieren!
> http://freemail.web.de/club/landingpage.htm/?mc=025555
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>





-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br