WFS performance issue

[Frank Warmerdam]

On Thu, 24 Mar 2005 11:02:33 -0300, Fernando Simon <fsimon at univali.br> wrote:
> Hi folks,
>     I don't know much about OGC WFS, but I believe that I can help
> with Oracle issue. I will try to help.
>     About the performance problem for 4.4.x version and Oracle Spatial
> I implemented in maporaclespatial.c, by default, the call for
> SDO_FILTER Oracle Spatial operator, that use a bbox to perform any
> query. I used the rectObj (Mapserver Obj) as the bbox parameter for
> this Oracle Spatial operator. The call for this operator don't occur
> by default for older versions.
>     I don't know how WFS perform the query, what is the order for the
> calls. But I believe that 4.4.x version for Oracle Spatial querys the
> performance can be much better.
>     Well, I don't know if I helped, I tried to clarify some doubts.
> For Oracle Spatial issue we can help too.

Fernando,

What I would need is for you (at some point) to change maporacle so
that if the passed in rect is NULL that no spatial query would be
applied.  Assefa's changes should not result in any needed changes
in maporacle.c.  You will just start getting a FILTER expression for
layers in cases where you hadn't before.

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