[mapguide-users] King.Oracle 0.3.3

Tue Oct 24 21:18:07 EDT 2006

I'm not sure about performance comparisons, but I've always liked the idea of displaying my data directly from its source.  In my case it's Oracle Spatial.  I'm not one for file maintenance and making sure the data from Oracle Spatial is being brought over and converted into an SDF for Mapguide to read.   

In terms of the previous Mapguide 6.x versions, SDF was always the fastest in terms of displaying data in Mapguide.  But that's not to say that displaying data from Oracle Spatial was slow.  With some tuning and tweaking, Mapguide 6.x displayed data from Oracle Spatial superbly.  That's one of the reasons we chose to go with Mapguide.  

I just hope Enterprise/MGOS gets to the that level one day.

Juan Butler - Senior Programmer/Analyst
GIS Applications
Pinellas County Information Systems
jpbutler at pinellascounty.org

Please note: All mail sent to and from Pinellas County Government is subject to the Public Records Law of Florida.

________________________________

From: Paul Spencer [mailto:pspencer at dmsolutions.ca]
Sent: Tue 10/24/2006 8:47 PM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] King.Oracle 0.3.3

Several people have indicated excellent performance.  I have no 
experience with Oracle so I am curious if anyone has comments on 
performance relative to SDF?  Faster/slower?  Conditions under which 
it is faster/slower?

Cheers

Paul

On 24-Oct-06, at 6:28 PM, Haris Kurtagic wrote:

> I am getting this after login as Anonymous:
>
> An unclassified exception occurred. Exception occurred in method 
> MgWebLayout.ParseWebLayoutDefinition at line 294 in file c:
> \build_tux_area\mgdev\web\src\webapp\WebLayout.cpp
>
>
> Haris
>
> From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us]
> Sent: Tuesday, October 24, 2006 11:19 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] King.Oracle 0.3.3
>
> Haris:
>
>
>
> I'm seeing some other strange things.  The labels on some of my 
> polygons have odd characters in them.  Not sure where these are 
> coming from.
>
>
>
> http://gis.co.pinellas.fl.us/mapguide/mapviewerajax/?
> WEBLAYOUT=Library%3a%2f%2fPinellas%2fLayouts%
> 2fkingtest.WebLayout&LOCALE=en
>
>
>
> Use Anonymous for the user and zoom into a scale of at least 10,000 
> to pull up the parcels.  Then hover over one of them.   The 
> performance for these coming up is great.
>
>
>
> I'm just stumped on why the Evacuation Routes are not displaying 
> with the parcels.  Same coordinate system in the database.  The 
> layer previews fine too.  I can see them when editing the layer 
> style; just can't see them when I place the layer in the map.
>
>
>
> Juan Butler - Senior Programmer/Analyst
> GIS Applications
> Pinellas County Information Systems
> jpbutler at pinellascounty.org
>
>
>
> Please note: All mail sent to and from Pinellas County Government 
> is subject to the Public Records Law of Florida.
>
>
>
>
>
> From: Haris Kurtagic [mailto:haris at sl-king.com]
> Sent: Tuesday, October 24, 2006 4:43 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] King.Oracle 0.3.3
>
>
>
> Hi Juan,
>
>
>
> I am looking at this memory usage.
>
>
>
> Which version of MG are you using ?
>
>
>
> Haris
>
>
>
> From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us]
> Sent: Tuesday, October 24, 2006 10:26 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] King.Oracle 0.3.3
>
> True...I was thinking about it.  I would just need to construct the 
> GEOMETRY in the view.   I'll try it out.
>
>
>
> Thanks.
>
>
>
> Juan Butler - Senior Programmer/Analyst
> GIS Applications
> Pinellas County Information Systems
> jpbutler at pinellascounty.org
>
>
>
> Please note: All mail sent to and from Pinellas County Government 
> is subject to the Public Records Law of Florida.
>
>
>
>
>
> From: Haris Kurtagic [mailto:haris at sl-king.com]
> Sent: Tuesday, October 24, 2006 3:31 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] King.Oracle 0.3.3
>
>
>
> I would suspect it is a memory leak in provider. I will check it.
>
>
>
> "I just wish I could use this for non Oracle Spatial tables with 
> coordinate fields" - you mean like displaying points from x,y 
> columns ?
>
>
>
> Beside suporting it in provider, one of the ways could be to create 
> a view in Oracle for it.
>
>
>
> Haris
>
>
>
> From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us]
> Sent: Tuesday, October 24, 2006 7:52 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] King.Oracle 0.3.3
>
> Haris:
>
>
>
> I'm testing this now and it seems that your provider is pulling up 
> the spatial data much faster.  The only problem that I'm running 
> into is the server process is eating up memory at a large clip when 
> adding more layers from Oracle.  It's gotten up to over a GIG.   
> I've had to shutdown Mapguide server completely and then restart 
> it.  The memory usage will go back up as I interact with more 
> Oracle spatial layers.  Not sure if it's more on the Mapguide 
> server side or the provider.
>
>
>
> I just wish I could use this for non Oracle Spatial tables with 
> coordinate fields.  The ODBC provider will not show tables for me.
>
>
>
> Juan Butler - Senior Programmer/Analyst
> GIS Applications
> Pinellas County Information Systems
> jpbutler at pinellascounty.org
>
>
>
> Please note: All mail sent to and from Pinellas County Government 
> is subject to the Public Records Law of Florida.
>
>
>
>
>
> From: Haris Kurtagic [mailto:haris at sl-king.com]
> Sent: Tuesday, October 24, 2006 7:17 AM
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] King.Oracle 0.3.3
>
>
>
> Hi,
>
>
>
> newer version of King.Oracle 0.3.3 provider:
>
> Support for Spatial Views
> It will display views based on spatial tables. Views needs to be 
> added into sdo_geom_metadata for provider to find them.
> Get it here: www.sl-king.com/fdooracle
>
>
>
> Haris
>
>
>
>
>
>

+-----------------------------------------------------------------+
|Paul Spencer                          pspencer at dmsolutions.ca    |
+-----------------------------------------------------------------+
|Chief Technology Officer                                         |
|DM Solutions Group Inc                http://www.dmsolutions.ca/ |
+-----------------------------------------------------------------+

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061024/06b99350/attachment.html