[mapguide-users] King.Oracle 0.3.3

[Paul Spencer]

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/ |
+-----------------------------------------------------------------+