<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>Re: [mapguide-users] bad performance with mysql or sql server</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText1844 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>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?</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> SER&TEC Antonio Lucas
[mailto:alucas@srtec.com]<BR><B>Sent:</B> Fri 10/20/2006 3:57 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>
<P><FONT size=2>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.<BR><BR></FONT></P></DIV>
</BODY>
</HTML>