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