<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Re: [mapguide-users] bad performance with mysql or sql server</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
font-face
{font-family:Tahoma;}
font-face
{font-family:Tahoma;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle18
{font-family:Arial;
color:navy;}
span.emailstyle19
{font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Correct. The SDF/SHP providers are very
fast and don’t need any caching, but any of the RDBMS providers most definitely
benefit from the caching (Oracle, SQL Server, ODBC, etc…)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Bill Ten Broeck
(External) <br>
<b><span style='font-weight:bold'>Sent:</span></b> October 23, 2006 11:05 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Bruce Dechant<br>
<b><span style='font-weight:bold'>Cc:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] bad
performance with mysql or sql server</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div id=idOWAReplyText9959>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>So this would be due then to the
secondary datasource be accessed via the ODBC provider? Because if I take that
out of the mix, everything renders splendidly. (Of course, I'm theming from the
secondary source :)</span></font><o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Bruce
Dechant [mailto:bruce.dechant@autodesk.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Mon 10/23/2006 1:01 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Bill Tenbroeck<br>
<b><span style='font-weight:bold'>Cc:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] bad
performance with mysql or sql server</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Bill,</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>That is expected behavior as the 1<sup>st</sup>
time you load a layer nothing is cached by the MapGuide server. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The <st1:City w:st="on"><st1:place w:st="on">Ajax</st1:place></st1:City>
viewer is actually faster so I would stick with that. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I know MapGuide’s performance will
only get better as new versions of FDO come out and performance improvements
are made to the MapGuide server.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Bruce</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Bill Ten Broeck
(External) <br>
<b><span style='font-weight:bold'>Sent:</span></b> October 23, 2006 10:55 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Bruce Dechant<br>
<b><span style='font-weight:bold'>Cc:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] bad
performance with mysql or sql server</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div id=idOWAReplyText37537>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>Hey Bruce, that seems to be the case -
first time is slow whether I pull it up in Studio or via a browser, and then
afterwords it's fast. Currently I'm using the <st1:City w:st="on"><st1:place
w:st="on">Ajax</st1:place></st1:City> viewer, though easy enough to change if
helpful.</span></font><o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Bruce
Dechant [mailto:bruce.dechant@autodesk.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Mon 10/23/2006 11:42 AM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] bad
performance with mysql or sql server</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Bill,</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>When the layer takes a long period of time
is it always the 1<sup>st</sup> time you load it? If you reload the layer a 2<sup>nd</sup>/3<sup>rd</sup>/etc
time is it fast?</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Are you using the DWF viewer or <st1:City
w:st="on"><st1:place w:st="on">AJAX</st1:place></st1:City> viewer?</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks,</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Bruce</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Bill Ten Broeck
(External) <br>
<b><span style='font-weight:bold'>Sent:</span></b> October 20, 2006 6:22 AM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] bad
performance with mysql or sql server</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div id=idOWAReplyText1844>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>I'm using SQL Server as a secondary table
via ODBC. There are times when it takes 2 minutes for a layer using the
secondary datasource to load and other times it loads immediately. I'm on
1.0.2. Anyone have a similar experience or thoughts?</span></font><o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
SER&TEC Antonio Lucas [mailto:alucas@srtec.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Fri 10/20/2006 3:57 AM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [mapguide-users] bad
performance with mysql or sql server</span></font><o:p></o:p></p>
</div>
<div>
<p style='margin-bottom:12.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>Jason Birch escribió:<br>
> Hi Antonio,<br>
> <br>
> I'm assuming that you're using <st1:City w:st="on"><st1:place w:st="on">Enterprise</st1:place></st1:City>?
There is a HUGE performance difference between the rdbms drivers in MGOS 1.0.1
and 1.0.2, and I'm pretty sure that you'll see the same benefit if you upgrade
your Map 3D to SP3 (read about the performance improvements in the SP readme)
and your MapGuide Enterprise to SP1... when it's released. It gets more
Q/A than the open source release, which is a large part of what you're paying
for with <st1:City w:st="on"><st1:place w:st="on">Enterprise</st1:place></st1:City>.<br>
> <br>
> I believe that a lot of the changes are around FDO connection pooling and
changes in the way that the schema is requested in the rdbms providers.
Haris has noted that it has made a big difference for the open source
King.Oracle provider.<br>
> <br>
> Jason<br>
><br>
> ________________________________<br>
><br>
> From: SER&TEC Antonio Lucas [<a href="mailto:alucas@srtec.com">mailto:alucas@srtec.com</a>]<br>
> Sent: Fri 2006-10-20 12:03 AM<br>
> To: users@mapguide.osgeo.org<br>
> Subject: [mapguide-users] bad performance with mysql or sql server<br>
><br>
><br>
><br>
> Hello,<br>
><br>
> I'm testing my project changing sdf based layers to fdo mysql
or sql<br>
> server as data sources. I'm loading data from Autodesk Map 3D 2007 and<br>
> authoring with Studio but the performance is very very bad. It seems<br>
> that fdo provider for relational database works slow.<br>
><br>
> (sorry for my english...)<br>
><br>
> Thanks.<br>
> --<br>
> ------------------------------------------------------------------------<br>
><br>
> Antonio Lucas<br>
><br>
> Software Engineer<br>
><br>
> alucas@sercad.com <<a href="mailto:alucas@sercad.com">mailto:alucas@sercad.com</a>>
www.sercad.com<br>
> <<a href="http://www.sercad.com">http://www.sercad.com</a>><br>
><br>
> 963·959·513<br>
><br>
> <br>
><br>
> Fax 963·731·756<br>
><br>
>
SER&TEC<br>
> avda. Ausias March 79 - 1<br>
> 46013 <st1:country-region w:st="on"><st1:place w:st="on">Valencia</st1:place></st1:country-region><br>
><br>
> Este mensaje puede contener información confidencial, privilegiada o<br>
> datos de carácter personal. Si usted no es el destinatario indicado en<br>
> el mismo o el responsable de su entrega, le rogamos no copie o entregue<br>
> este mensaje a nadie más. En dicho caso, por favor, destruya este<br>
> mensaje y comunique a Sercitec Servicios Informáticos S.L. su recepción.<br>
> Las opiniones, conclusiones y demás información incluida en este mensaje<br>
> que no está relacionada con asuntos profesionales de Servitec Servicios<br>
> Informáticos S.L. se entenderá que nunca se ha dado, ni está respaldada<br>
> por Servitec Servicios Informáticos S.L.<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>
><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>
><br>
> Hi Antonio,<br>
> <br>
> I'm assuming that you're using <st1:City w:st="on"><st1:place w:st="on">Enterprise</st1:place></st1:City>?
There is a HUGE performance difference between the rdbms drivers in MGOS 1.0.1
and 1.0.2, and I'm pretty sure that you'll see the same benefit if you upgrade
your Map 3D to SP3 (read about the performance improvements in the SP readme)
and your MapGuide Enterprise to SP1... when it's released. It gets more
Q/A than the open source release, which is a large part of what you're paying
for with <st1:City w:st="on"><st1:place w:st="on">Enterprise</st1:place></st1:City>.<br>
> <br>
> I believe that a lot of the changes are around FDO connection pooling and
changes in the way that the schema is requested in the rdbms providers.
Haris has noted that it has made a big difference for the open source
King.Oracle provider.<br>
> <br>
> Jason<br>
><br>
> ________________________________<br>
><br>
> From: SER&TEC Antonio Lucas [<a href="mailto:alucas@srtec.com">mailto:alucas@srtec.com</a>]<br>
> Sent: Fri 2006-10-20 12:03 AM<br>
> To: users@mapguide.osgeo.org<br>
> Subject: [mapguide-users] bad performance with mysql or sql server<br>
><br>
><br>
><br>
> Hello,<br>
><br>
> I'm testing my project changing sdf based layers to fdo mysql
or sql<br>
> server as data sources. I'm loading data from Autodesk Map 3D 2007 and<br>
> authoring with Studio but the performance is very very bad. It seems<br>
> that fdo provider for relational database works slow.<br>
><br>
> (sorry for my english...)<br>
><br>
> Thanks.<br>
> --<br>
> ------------------------------------------------------------------------<br>
><br>
> Antonio Lucas<br>
><br>
> Software Engineer<br>
><br>
> alucas@sercad.com <<a href="mailto:alucas@sercad.com">mailto:alucas@sercad.com</a>>
www.sercad.com<br>
> <<a href="http://www.sercad.com">http://www.sercad.com</a>><br>
><br>
> 963·959·513<br>
><br>
> <br>
><br>
> Fax 963·731·756<br>
><br>
>
SER&TEC<br>
> avda. Ausias March 79 - 1<br>
> 46013 <st1:country-region w:st="on"><st1:place w:st="on">Valencia</st1:place></st1:country-region><br>
><br>
> Este mensaje puede contener información confidencial, privilegiada o<br>
> datos de carácter personal. Si usted no es el destinatario indicado en<br>
> el mismo o el responsable de su entrega, le rogamos no copie o entregue<br>
> este mensaje a nadie más. En dicho caso, por favor, destruya este<br>
> mensaje y comunique a Sercitec Servicios Informáticos S.L. su recepción.<br>
> Las opiniones, conclusiones y demás información incluida en este mensaje<br>
> que no está relacionada con asuntos profesionales de Servitec Servicios<br>
> Informáticos S.L. se entenderá que nunca se ha dado, ni está respaldada<br>
> por Servitec Servicios Informáticos S.L.<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>
><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>
Hello Jason,<br>
<br>
Sorry, I forget to post my configuration:<br>
<br>
- SQL Server 2005 + Autodesk Map 3D 2007 SP3 + MGE and java viewer<br>
- Mysql 5.0 + Autodesk Map 3D 2007 SP3 + MGOS 1.0.2 and the latest mysql<br>
fdo provider (I think R071...).<br>
<br>
In both cases, the performance is bad in comparison with sdf based layers.<br>
<br>
Thanks.<br>
<br>
--<br>
------------------------------------------------------------------------<br>
<br>
Antonio Lucas<br>
<br>
Software Engineer<br>
<br>
alucas@sercad.com <<a href="mailto:alucas@sercad.com">mailto:alucas@sercad.com</a>>
www.sercad.com<br>
<<a href="http://www.sercad.com">http://www.sercad.com</a>><br>
<br>
963·959·513<br>
<br>
<br>
<br>
Fax 963·731·756<br>
<br>
SER&TEC<br>
avda. Ausias March 79 - 1<br>
46013 <st1:country-region w:st="on"><st1:place w:st="on">Valencia</st1:place></st1:country-region><br>
<br>
Este mensaje puede contener información confidencial, privilegiada o<br>
datos de carácter personal. Si usted no es el destinatario indicado en<br>
el mismo o el responsable de su entrega, le rogamos no copie o entregue<br>
este mensaje a nadie más. En dicho caso, por favor, destruya este<br>
mensaje y comunique a Sercitec Servicios Informáticos S.L. su recepción.<br>
Las opiniones, conclusiones y demás información incluida en este mensaje<br>
que no está relacionada con asuntos profesionales de Servitec Servicios<br>
Informáticos S.L. se entenderá que nunca se ha dado, ni está respaldada<br>
por Servitec Servicios Informáticos S.L.</span></font><o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>