[Geoserver-devel] problem getting messages to geoserver-devel (fwd)

Chris_Holmes1 · December 14, 2004, 6:52am

---------- Forwarded message ----------
Date: Tue, 14 Dec 2004 14:47:16 -0000
From: Chris Faulkner <christopher.faulkner@anonymised.com>
To: cholmes@anonymised.com
Subject: problem getting messages to geoserver-devel

Hi Chris

We have previously been in touch about Oracle and geoserver. I have been
having difficulties posting to the list, despite the fact that I am
subscribed.

This is my message

Hi

I have noticed that in 1.2.3, the WMS Oracle filters now work like this

SELECT [fields] FROM [table] WHERE NOT
SDO_RELATE("GEOM",MDSYS.SDO_GEOMETRY(2003,81989,NULL,MDSYS.SDO_ELEM_INFO

_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(298500.0,98500.0,298500.0,9900

0.0,299000.0,99000.0,299000.0,98500.0,298500.0,98500.0)),'mask=disjoint

querytype=WINDOW') = 'TRUE'

In 1.2.0, they were like this

SELECT [fields] FROM [table] WHERE (

SDO_RELATE("GEOM",

MDSYS.SDO_GEOMETRY(2003,

81989,NULL,

MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),

MDSYS.SDO_ORDINATE_ARRAY(298500.0,98500.0,298500.0,99000.0,299000.0,9900

0.0,299000.0,98500.0,298500.0,98500.0)),'mask=anyinteract

querytype=WINDOW') = 'TRUE'

AND SDO_RELATE("GEOM",

MDSYS.SDO_GEOMETRY(2003,81989,NULL,

MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),

MDSYS.SDO_ORDINATE_ARRAY(298500.0,98500.0,298500.0,99000.0,299000.0,9900

0.0,299000.0,98500.0,298500.0,98500.0)),'mask=anyinteract

querytype=WINDOW') = 'TRUE' )

Whilst there was some inefficiency in 1.2.0, through the repetition of
the SDO_RELATE operator, the use of "NOT" and mask=disjoint in 1.2.3 is
MUCH worse. On my data, 1.2.3 is unusable - it is so slow.

Why was this change made ?

Thanks

Chris

Chris_Holmes1 · December 14, 2004, 6:57am

The change was made because I thought it would not affect performance, and
I noticed in a few tests I made that anyinteract did not actually return
the exact same results as a true NOT DISJOINT, as it should if we are to
use it for bbox and intersects. But for 1.2.4 we changed it back, since
it was so much slower, and I will revisit later to see if I can replicate
my errors and email oracle and all. I was supposed to get 1.2.4 out last
week, but my computer broke, so right now I am trying to download cygwin
to see if I cant get a release out. But until then you can just download
the oracle 1.2.4 datastore extension from
http://sourceforge.net/project/showfiles.php?group_id=25086&package_id=129885&release_id=271218

This has a bit more detail as to why the change was made, and fixes it to
the old (faster but possible inaccurate) way of doing things. THe
instructions in the downloads readme should be sufficient.

best regards,

Chris

On Tue, 14 Dec 2004, Chris Holmes wrote:

---------- Forwarded message ----------
Date: Tue, 14 Dec 2004 14:47:16 -0000
From: Chris Faulkner <christopher.faulkner@anonymised.com>
To: cholmes@anonymised.com
Subject: problem getting messages to geoserver-devel

Hi Chris

We have previously been in touch about Oracle and geoserver. I have been
having difficulties posting to the list, despite the fact that I am
subscribed.

This is my message

Hi

I have noticed that in 1.2.3, the WMS Oracle filters now work like this

SELECT [fields] FROM [table] WHERE NOT
SDO_RELATE("GEOM",MDSYS.SDO_GEOMETRY(2003,81989,NULL,MDSYS.SDO_ELEM_INFO

_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(298500.0,98500.0,298500.0,9900

0.0,299000.0,99000.0,299000.0,98500.0,298500.0,98500.0)),'mask=disjoint

querytype=WINDOW') = 'TRUE'

In 1.2.0, they were like this

SELECT [fields] FROM [table] WHERE (

SDO_RELATE("GEOM",

MDSYS.SDO_GEOMETRY(2003,

81989,NULL,

MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),

MDSYS.SDO_ORDINATE_ARRAY(298500.0,98500.0,298500.0,99000.0,299000.0,9900

0.0,299000.0,98500.0,298500.0,98500.0)),'mask=anyinteract

querytype=WINDOW') = 'TRUE'

AND SDO_RELATE("GEOM",

MDSYS.SDO_GEOMETRY(2003,81989,NULL,

MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),

MDSYS.SDO_ORDINATE_ARRAY(298500.0,98500.0,298500.0,99000.0,299000.0,9900

0.0,299000.0,98500.0,298500.0,98500.0)),'mask=anyinteract

querytype=WINDOW') = 'TRUE' )

Whilst there was some inefficiency in 1.2.0, through the repetition of
the SDO_RELATE operator, the use of "NOT" and mask=disjoint in 1.2.3 is
MUCH worse. On my data, 1.2.3 is unusable - it is so slow.

Why was this change made ?

Thanks

Chris

-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--