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

Johann Nothbauer nothbauer at rmdata.at
Tue Nov 21 01:33:06 EST 2006


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






More information about the Mapguide-users mailing list