<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [mapguide-users] King.Oracle 0.3.3</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5450.4" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=781404803-25102006><FONT face=Arial
color=#0000ff size=2>I agree that with MapGuide 6.5, Oracle Spatial
is nearly as fast as SDF. Nothing beats SDF, however. It's hard
to say with the current versions of MGOS and the King provider since I doubt
that anyone has bench marked it against SDF+ to date, but I would ultimately
expect similar performance. The same goes for the Autodesk Oracle Spatial
FDO provider: I expect that the improvements that Autodesk are making to it will
bring it more back in line with performance of MapGuide 6.5. I saw a beta
version of the patched provider about a month ago, and my tests indicated that
it will be much, much better than the current version.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Tahoma size=1>Andy Morsell, P.E.</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Tahoma size=1>Spatial Integrators,
Inc.</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Tahoma size=1><A
href="http://www.SpatialGIS.com">http://www.SpatialGIS.com</A></FONT></SPAN>
</P>
<DIV>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Butler, Juan P
[mailto:jpbutler@co.pinellas.fl.us] <BR><B>Sent:</B> Tuesday, October 24, 2006
6:18 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] King.Oracle 0.3.3<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText64454 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>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.
</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>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. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I just hope Enterprise/MGOS gets to the
that level one day.</FONT></DIV></DIV>
<DIV id=idSignature28617 dir=ltr>
<DIV><FONT face=Arial color=#000000 size=2>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Juan Butler - Senior
Programmer/Analyst<BR>GIS Applications<BR>Pinellas County Information
Systems<BR>jpbutler@pinellascounty.org<BR><BR></SPAN><FONT face=Arial
size=1><SPAN style="FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">Please note: All mail
sent to and from Pinellas County Government is subject to the Public Records Law
of Florida.</SPAN></FONT></FONT></DIV></FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Paul Spencer
[mailto:pspencer@dmsolutions.ca]<BR><B>Sent:</B> Tue 10/24/2006 8:47
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> Re:
[mapguide-users] King.Oracle 0.3.3<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Several people have indicated excellent performance. I
have no <BR>experience with Oracle so I am curious if anyone has comments
on <BR>performance relative to SDF? Faster/slower? Conditions
under which <BR>it is faster/slower?<BR><BR>Cheers<BR><BR>Paul<BR><BR>On
24-Oct-06, at 6:28 PM, Haris Kurtagic wrote:<BR><BR>> I am getting this after
login as Anonymous:<BR>><BR>> An unclassified exception occurred.
Exception occurred in method <BR>> MgWebLayout.ParseWebLayoutDefinition
at line 294 in file c:<BR>>
\build_tux_area\mgdev\web\src\webapp\WebLayout.cpp<BR>><BR>><BR>>
Haris<BR>><BR>> From: Butler, Juan P [<A
href="mailto:jpbutler@co.pinellas.fl.us">mailto:jpbutler@co.pinellas.fl.us</A>]<BR>>
Sent: Tuesday, October 24, 2006 11:19 PM<BR>> To:
users@mapguide.osgeo.org<BR>> Subject: RE: [mapguide-users] King.Oracle
0.3.3<BR>><BR>> Haris:<BR>><BR>><BR>><BR>> I’m seeing some
other strange things. The labels on some of my <BR>> polygons have
odd characters in them. Not sure where these are <BR>> coming
from.<BR>><BR>><BR>><BR>> <A
href="http://gis.co.pinellas.fl.us/mapguide/mapviewerajax/">http://gis.co.pinellas.fl.us/mapguide/mapviewerajax/</A>?<BR>>
WEBLAYOUT=Library%3a%2f%2fPinellas%2fLayouts%<BR>>
2fkingtest.WebLayout&LOCALE=en<BR>><BR>><BR>><BR>> Use Anonymous
for the user and zoom into a scale of at least 10,000 <BR>> to pull up
the parcels. Then hover over one of them. The <BR>>
performance for these coming up is great.<BR>><BR>><BR>><BR>> I’m
just stumped on why the Evacuation Routes are not displaying <BR>> with
the parcels. Same coordinate system in the database.
The <BR>> layer previews fine too. I can see them when editing the
layer <BR>> style; just can’t see them when I place the layer in the
map.<BR>><BR>><BR>><BR>> Juan Butler - Senior
Programmer/Analyst<BR>> GIS Applications<BR>> Pinellas County Information
Systems<BR>> jpbutler@pinellascounty.org<BR>><BR>><BR>><BR>>
Please note: All mail sent to and from Pinellas County Government <BR>>
is subject to the Public Records Law of
Florida.<BR>><BR>><BR>><BR>><BR>><BR>> From: Haris Kurtagic
[<A href="mailto:haris@sl-king.com">mailto:haris@sl-king.com</A>]<BR>> Sent:
Tuesday, October 24, 2006 4:43 PM<BR>> To: users@mapguide.osgeo.org<BR>>
Subject: RE: [mapguide-users] King.Oracle 0.3.3<BR>><BR>><BR>><BR>>
Hi Juan,<BR>><BR>><BR>><BR>> I am looking at this memory
usage.<BR>><BR>><BR>><BR>> Which version of MG are you using
?<BR>><BR>><BR>><BR>> Haris<BR>><BR>><BR>><BR>> From:
Butler, Juan P [<A
href="mailto:jpbutler@co.pinellas.fl.us">mailto:jpbutler@co.pinellas.fl.us</A>]<BR>>
Sent: Tuesday, October 24, 2006 10:26 PM<BR>> To:
users@mapguide.osgeo.org<BR>> Subject: RE: [mapguide-users] King.Oracle
0.3.3<BR>><BR>> True…I was thinking about it. I would just need to
construct the <BR>> GEOMETRY in the view. I’ll try it
out.<BR>><BR>><BR>><BR>> Thanks.<BR>><BR>><BR>><BR>>
Juan Butler - Senior Programmer/Analyst<BR>> GIS Applications<BR>>
Pinellas County Information Systems<BR>>
jpbutler@pinellascounty.org<BR>><BR>><BR>><BR>> Please note: All
mail sent to and from Pinellas County Government <BR>> is subject to the
Public Records Law of Florida.<BR>><BR>><BR>><BR>><BR>><BR>>
From: Haris Kurtagic [<A
href="mailto:haris@sl-king.com">mailto:haris@sl-king.com</A>]<BR>> Sent:
Tuesday, October 24, 2006 3:31 PM<BR>> To: users@mapguide.osgeo.org<BR>>
Subject: RE: [mapguide-users] King.Oracle 0.3.3<BR>><BR>><BR>><BR>>
I would suspect it is a memory leak in provider. I will check
it.<BR>><BR>><BR>><BR>> "I just wish I could use this for non Oracle
Spatial tables with <BR>> coordinate fields" - you mean like displaying
points from x,y <BR>> columns ?<BR>><BR>><BR>><BR>> Beside
suporting it in provider, one of the ways could be to create <BR>> a
view in Oracle for it.<BR>><BR>><BR>><BR>>
Haris<BR>><BR>><BR>><BR>> From: Butler, Juan P [<A
href="mailto:jpbutler@co.pinellas.fl.us">mailto:jpbutler@co.pinellas.fl.us</A>]<BR>>
Sent: Tuesday, October 24, 2006 7:52 PM<BR>> To:
users@mapguide.osgeo.org<BR>> Subject: RE: [mapguide-users] King.Oracle
0.3.3<BR>><BR>> Haris:<BR>><BR>><BR>><BR>> I’m testing this
now and it seems that your provider is pulling up <BR>> the spatial data
much faster. The only problem that I’m running <BR>> into is the
server process is eating up memory at a large clip when <BR>> adding
more layers from Oracle. It’s gotten up to over a
GIG. <BR>> I’ve had to shutdown Mapguide server completely
and then restart <BR>> it. The memory usage will go back up as I
interact with more <BR>> Oracle spatial layers. Not sure if it’s
more on the Mapguide <BR>> server side or the
provider.<BR>><BR>><BR>><BR>> I just wish I could use this for non
Oracle Spatial tables with <BR>> coordinate fields. The ODBC
provider will not show tables for me.<BR>><BR>><BR>><BR>> Juan
Butler - Senior Programmer/Analyst<BR>> GIS Applications<BR>> Pinellas
County Information Systems<BR>>
jpbutler@pinellascounty.org<BR>><BR>><BR>><BR>> Please note: All
mail sent to and from Pinellas County Government <BR>> is subject to the
Public Records Law of Florida.<BR>><BR>><BR>><BR>><BR>><BR>>
From: Haris Kurtagic [<A
href="mailto:haris@sl-king.com">mailto:haris@sl-king.com</A>]<BR>> Sent:
Tuesday, October 24, 2006 7:17 AM<BR>> To: users@mapguide.osgeo.org<BR>>
Subject: [mapguide-users] King.Oracle 0.3.3<BR>><BR>><BR>><BR>>
Hi,<BR>><BR>><BR>><BR>> newer version of King.Oracle 0.3.3
provider:<BR>><BR>> Support for Spatial Views<BR>> It will display
views based on spatial tables. Views needs to be <BR>> added into
sdo_geom_metadata for provider to find them.<BR>> Get it here:
www.sl-king.com/fdooracle<BR>><BR>><BR>><BR>>
Haris<BR>><BR>><BR>><BR>><BR>><BR>><BR><BR>+-----------------------------------------------------------------+<BR>|Paul
Spencer
pspencer@dmsolutions.ca
|<BR>+-----------------------------------------------------------------+<BR>|Chief
Technology
Officer
|<BR>|DM Solutions Group
Inc
<A href="http://www.dmsolutions.ca/">http://www.dmsolutions.ca/</A>
|<BR>+-----------------------------------------------------------------+<BR><BR><BR><BR><BR><BR>---------------------------------------------------------------------<BR>To
unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org<BR>For additional
commands, e-mail:
users-help@mapguide.osgeo.org<BR><BR></FONT></P></DIV></BODY></HTML>