[mapguide-users] King.Oracle 0.3.3

[Butler, Juan P]

I'll do some testing today and post back the results and information.  Thanks for all of the help!
 
 
 
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: Wed 10/25/2006 5:39 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] King.Oracle 0.3.3


Hi Juan,
 
I am looking at this memory stuff and I can't see any memory leek's in provider. I've checked with unit test, code and also tried on several configurations.
Anyhow, I would like to check it further.
 
I would like to know which configuration you are having (Ent + 10.2 which client + one machine?)
For example I tried:
XP, MG Ent 2007, Oracle 10.1, Instant client, altogether on one machine
Altogether, It eats up around 620 MB and it stays around that no meter how much I query data.
 
You sad: "many layers", you noticed that adding layers is consuming memory ?
How many layers you are trying with ? All from Oracle I suppose?
 
Thanks,
Haris

________________________________

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, October 24, 2006 10:55 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] King.Oracle 0.3.3



Enterprise 2007.

 

________________________________

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061025/6378fe6d/attachment.html