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

[Haris Kurtagic]

Hi Johann,

I am doing something with King.Oracle provider which sounds something
like you could use.

I have created a special paremeters inside filter for King.Oracle
provider for optimizing queries.

This is not available yet in version 0.4.4, beacuse this is some
"workarroud" in provider I am using, not sure yet how to make it work in
"general way" how to make it to look nice without changes in FDO
interface itself. 
But it is working now with current versions of MapGuide and FDO.

If you want I could send you that version of provider to try it.

Haris

 

-----Original Message-----
From: Johann Nothbauer [mailto:nothbauer at rmdata.at] 
Sent: Friday, November 17, 2006 12:55 PM
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