if your looking at databases, PostGIS was consistently faster than<br>Oracle in the FOSS4G WMS shootout as a spatial back end<br><br><div class="gmail_quote">On Fri, Oct 30, 2009 at 4:10 AM, Martin Morrison <span dir="ltr"><<a href="mailto:martin.morrison@edsi.com">martin.morrison@edsi.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Dejan,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I have used 2.01, 2.02 and 2.1 RC1.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">The data I have is in State Plane coordinates, so I used
geometry.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">As far as the quality of the FDO, the AutoDESK guys wrote it.
It seems to be pretty good.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Martin</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Dejan Gregor<br>
<b>Sent:</b> Thursday, October 29, 2009 11:09 AM<div><div></div><div class="h5"><br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> Re: [mapguide-users] Oracle 10g Standard</div></div></span></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Dear Martin,</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">just two more questions. Which version of MapGuide Open
Source did you use for the production (2.0.2 or 2.1 beta)? I am concerned about
the quality of the FDO for MS SQL Server 2008.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Also, whcih type of geometry storage type did you use
(GEOGRAPHY) and did you migrate the data with any open source tools?</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Thanks!</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">Dejan</p>
</div>
<div>
<p class="MsoNormal">On Thu, Oct 29, 2009 at 16:03, Martin Morrison <<a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Dejan,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">On the production website we have full
blown SQL Server 2008. However, for the people editing the data and for
our demo use, we use SQL Server Express 2008. Both work well.
Please note the version number, you stated 2000 below. The Spatial
technology did not get added to SQL Server until the 2008 version.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Martin</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Dejan Gregor<br>
<b>Sent:</b> Thursday, October 29, 2009 10:55 AM<br>
<b>To:</b> MapGuide Users Mail List </span></p>
<div>
<p class="MsoNormal"><span style="font-size: 10pt;"><br>
<b>Subject:</b> Re: [mapguide-users] Oracle 10g Standard</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Dear
Martin,</p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">I
would like to know more about your implementation on the link privided below
(Macklenburg). Did you use SQL Server 2000 Express?</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Cheers,</p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">Dejan</p>
</div>
<div>
<p class="MsoNormal">On
Thu, Oct 29, 2009 at 15:04, Martin Morrison <<a href="mailto:martin.morrison@edsi.com" target="_blank">martin.morrison@edsi.com</a>>
wrote:</p>
<p class="MsoNormal">Yes.<br>
<br>
<a href="http://gis.edsi.com/mecklenburgmain.php" target="_blank">http://gis.edsi.com/mecklenburgmain.php</a><br>
<br>
Send me a note privately if you wish to discuss help with your specific
project.<br>
<span style="color: rgb(136, 136, 136);"><br>
Martin</span></p>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a></p>
</div>
<p class="MsoNormal"> </p>
</div></div></div>
</div>
<br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Zac Spitzer -<br><a href="http://zacster.blogspot.com">http://zacster.blogspot.com</a><br>+61 405 847 168<br>