[mapguide-users] ODBC DataSource creation

[Joel Carranza]

Our point data is stored as lat/lon in separate columns, not stored as a
Oracle spatial point. The king oracle doesn't support data stored in that
format does it?


zspitzer wrote:
> 
> any reason you not using king oracle, ie a native FDO provider rather than
> ODBC?
> 
> On Fri, Jun 19, 2009 at 11:01 AM, Joel Carranza<jec at gatekeeper.com> wrote:
>>
>> I'm creating a a new ODBC DataSource which is pointed at an Oracle
>> database.
>> This database has a lot of table/views in it, and when I go to define my
>> geometry properties and hit "Show tables", the takes a really long to to
>> populate. However, after a couple of minutes, everything comes up.
>> Wonderful! (This hadn't worked at all in older releases)
>>
>> However, after setting up everything the way I want it, I go to hit the
>> save
>> button and it takes a long time to save the datasource.
>>
>> Really long - like 15 minutes. (it did eventually complete though)
>>
>> Looking at the query log, we see that for each table that i defined an
>> x/y
>> column, the ODBC FDO is doing
>>
>> SELECT B.lat FROM tablename B
>> and then
>> SELECT B.lon FROM tablename B
>>
>> Ouch!Each of our tables are actually quite big, so this kind of query
>> takes
>> forever. I am guessing that the FDO is doing this to calculate the
>> spatial
>> extent of the data, but why would it do it this way? Why not using
>> MIN/MAX?
>> Is there something wrong with my setup that may be causing the code to go
>> down this path?
>>
>> I am setting up against Views  inside an Oracle 10.2 database with the
>> latest MapGuide Open Source 2.1 beta. I think that I have seen this
>> behavior
>> in earlier releases.
>>
>> Any thoughts?
>>
>> Many thanks
>>
>> Joel Carranza
>> Gatekeeper Systems
>> jec at gatekeeper.com
>> --
>> View this message in context:
>> http://n2.nabble.com/ODBC-DataSource-creation-tp3116879p3116879.html
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
> 
> 
> 
> -- 
> Zac Spitzer -
> http://zacster.blogspot.com
> +61 405 847 168
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/ODBC-DataSource-creation-tp3116879p3116891.html
Sent from the MapGuide Users mailing list archive at Nabble.com.