<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html >
<head>
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<title>Re: [mapguide-users] bad performance with mysql or sql server</title>
<style>
<!--
font-face
{font-family:Tahoma;}
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
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{
font-family:Arial;
color:navy;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<DIV id=idOWAReplyText37537 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>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 Ajax viewer, though easy
enough to change if helpful.</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Bruce Dechant
[mailto:bruce.dechant@autodesk.com]<BR><B>Sent:</B> Mon 10/23/2006 11:42
AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] bad performance with mysql or sql server<BR></FONT><BR></DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Bill,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Are you using the DWF
viewer or AJAX viewer?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Bruce</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV id=idOWAReplyText1844>
<DIV>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">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></P></DIV></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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></P></DIV>
<DIV>
<P style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Jason Birch escribió:<BR>> Hi
Antonio,<BR>> <BR>> I'm assuming that you're using Enterprise?
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 Enterprise.<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
Valencia<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
Enterprise? 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 Enterprise.<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
Valencia<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
Valencia<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></P></DIV></DIV></DIV>
</body>
</html>