WFS performance issue

[Fernando Simon]

Hi,
    Thanks Franks for the hints. I will do this issue when the rect
parramter is NULL. In this case I will apply the same query when the
user specify USING NONE parameter in data string.
    Thanks for all.

----------------------------------------------------------------
Fernando Simon - simon at inf.univali.br
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada
http://g10.cttmar.univali.br
----------------------------------------------------------------


Citando Frank Warmerdam <fwarmerdam at GMAIL.COM>:

> 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
>




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