[mapguide-users] Query for Oracle SDO Data without using SDO_FILTER

Haris Kurtagic haris at sl-king.com
Wed Nov 22 05:24:39 EST 2006


Hi Johann,

I think you are not doing anything wrong but MapGuide is always sending an spatial condition when querying data.

Here is a version (0.4.5) of King.Oracle provider with special Filter parameters.
It will allow you to skip spatial filter set from MapGuide.

In MapGuide go to layer setup and select "Filter applied to data".
Go to advanced tab and enter KingOracle.NoSpatialQuery=TRUE   (if you click "Validate" - ignore message generated by studio)

This filter parameter will be processed and provider will skip any spatial conditions set by MapGuide
You can combine this with other "normal" conditions like: KingOracle.NoSpatialQuery=TRUE and UL_MID=16234249

http://www.sl-king.com/fdooracle/download/FdoKingOracle_Win32_InstantClient_v0_4_5.zip
http://www.sl-king.com/fdooracle/download/FdoKingOracle_Win32_v0_4_5.zip

This can be also used to display points x,y columns (no sdo_geometry column) and tables without spatial index at all.
I am also using this kind of parameters to generate special Oracle optimizer commands.

This is not "official" version, because this is my workaround, but if it is needed and I can put it in..

Haris


-----Original Message-----
From: Johann Nothbauer [mailto:nothbauer at rmdata.at] 
Sent: Tuesday, November 21, 2006 7:33 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] Query for Oracle SDO Data without using SDO_FILTER

Hi Andy!

You are right, I am using the King Oracle Spatial Provider.
Would this be a difference? I just can't see a way to "turn off" Spatial Filtering in Mapguide.
I can do that in Autodesk Map 2007 using the King Oracle Provider (just not adding a Spatial Filter). So I thought, the Provider wasn't the Problem.

What am I getting wrong here?

Andy Morsell schrieb:
> If you are using MapGuide Open Source are you using the King Oracle 
> Spatial provider?  The only way to use the Autodesk Oracle Spatial 
> provider is to use MapGuide Enterprise.
> 
> 
> Andy
> 
> -----Original Message-----
> From: Johann Nothbauer [mailto:nothbauer at rmdata.at]
> Sent: Monday, November 20, 2006 7:20 AM
> To: OSGEO Mapguide Users
> Subject: [mapguide-users] Query for Oracle SDO Data without using 
> SDO_FILTER
> 
> Hi Andy!
> 
> I'm using Mapguide Open Source 1.0.2.
> I could try to use Mapguide Enterprise, for we are a Autodesk Partner.
> 
> I'm only wondering how Mapguide would automatically decide when not to 
> use the Spatial Filter?
> 
> cheers,
> Johann
> 
> 
> 
> Andy Morsell wrote (Date: Fri, 17 Nov 2006 08:54:22 -0800):
> 
> Are you using MapGuide Enterprise with Service Pack 1?  SP1 fixed 
> quite a few of the Oracle Spatial performance issues.
> 
> 
> Andy
> 
> -----Original Message-----
> From: Johann Nothbauer [mailto:nothbauer at rmdata.at]
> Sent: Friday, November 17, 2006 3:55 AM
> To: OSGEO Mapguide Users
> Subject: [mapguide-users] Query for Oracle SDO Data without using 
> SDO_FILTER
> 
> Is there any way to prevent Mapguide from using the SDO_FILTER()=='TRUE'
> - Clause for Layers of Oracle Spatial Feature Sources?
> 
> I'm trying to produce an overview layer from an Oracle table 
> containing a lot of Line Features (> 2 million). The Features, that 
> should be part of the overview can be found with a very simple 
> predicate (e.g.: "where layername =
> 'GG'") and are very few (< 1000). My problem is, that Mapguide always 
> sends a combined query (simple predicate plus spatial query with "extent all").
> The Oracle explain plan shows, that internally ALL Features are 
> fetched into memory as a result of the spatial query only to be 
> filtered with the much "better" simple predicate.
> I see this is a problem of the Oracle Cost Based Optimizer.
> 
> A nice workaround could be a "Don't use Spatial Filter" Checkbox in 
> Mapguide (as available in Oracle Mapviewer).
> 
> Would this be possible for the currrent Design?
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> 

--
Mit freundlichen Grüßen,

Johann Nothbauer
(Entwicklung)	
________________________________________________________________________
rmDATA GmbH
Ihr Partner für IT-Dienstleistungen in der Vermessung und Geoinformation

Prinz Eugen Str. 12, A-7400 Oberwart
Tel: +43/(0)3352/384 82 - 0 (Fax -76)
e-mail: nothbauer at rmdata.at
www.rmdata.at



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org





More information about the Mapguide_users mailing list