[mapguide-users] bad performance with mysql or sql server
Bill Tenbroeck
btenbroeck at itssg.com
Fri Oct 20 08:21:52 EDT 2006
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?
________________________________
From: SER&TEC Antonio Lucas [mailto:alucas at srtec.com]
Sent: Fri 10/20/2006 3:57 AM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] bad performance with mysql or sql server
Jason Birch escribió:
> Hi Antonio,
>
> 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.
>
> 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.
>
> Jason
>
> ________________________________
>
> From: SER&TEC Antonio Lucas [mailto:alucas at srtec.com]
> Sent: Fri 2006-10-20 12:03 AM
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] bad performance with mysql or sql server
>
>
>
> Hello,
>
> I'm testing my project changing sdf based layers to fdo mysql or sql
> server as data sources. I'm loading data from Autodesk Map 3D 2007 and
> authoring with Studio but the performance is very very bad. It seems
> that fdo provider for relational database works slow.
>
> (sorry for my english...)
>
> Thanks.
> --
> ------------------------------------------------------------------------
>
> Antonio Lucas
>
> Software Engineer
>
> alucas at sercad.com <mailto:alucas at sercad.com> www.sercad.com
> <http://www.sercad.com>
>
> 963·959·513
>
>
>
> Fax 963·731·756
>
> SER&TEC
> avda. Ausias March 79 - 1
> 46013 Valencia
>
> Este mensaje puede contener información confidencial, privilegiada o
> datos de carácter personal. Si usted no es el destinatario indicado en
> el mismo o el responsable de su entrega, le rogamos no copie o entregue
> este mensaje a nadie más. En dicho caso, por favor, destruya este
> mensaje y comunique a Sercitec Servicios Informáticos S.L. su recepción.
> Las opiniones, conclusiones y demás información incluida en este mensaje
> que no está relacionada con asuntos profesionales de Servitec Servicios
> Informáticos S.L. se entenderá que nunca se ha dado, ni está respaldada
> por Servitec Servicios Informáticos S.L.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> ------------------------------------------------------------------------
>
> Hi Antonio,
>
> 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.
>
> 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.
>
> Jason
>
> ________________________________
>
> From: SER&TEC Antonio Lucas [mailto:alucas at srtec.com]
> Sent: Fri 2006-10-20 12:03 AM
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] bad performance with mysql or sql server
>
>
>
> Hello,
>
> I'm testing my project changing sdf based layers to fdo mysql or sql
> server as data sources. I'm loading data from Autodesk Map 3D 2007 and
> authoring with Studio but the performance is very very bad. It seems
> that fdo provider for relational database works slow.
>
> (sorry for my english...)
>
> Thanks.
> --
> ------------------------------------------------------------------------
>
> Antonio Lucas
>
> Software Engineer
>
> alucas at sercad.com <mailto:alucas at sercad.com> www.sercad.com
> <http://www.sercad.com>
>
> 963·959·513
>
>
>
> Fax 963·731·756
>
> SER&TEC
> avda. Ausias March 79 - 1
> 46013 Valencia
>
> Este mensaje puede contener información confidencial, privilegiada o
> datos de carácter personal. Si usted no es el destinatario indicado en
> el mismo o el responsable de su entrega, le rogamos no copie o entregue
> este mensaje a nadie más. En dicho caso, por favor, destruya este
> mensaje y comunique a Sercitec Servicios Informáticos S.L. su recepción.
> Las opiniones, conclusiones y demás información incluida en este mensaje
> que no está relacionada con asuntos profesionales de Servitec Servicios
> Informáticos S.L. se entenderá que nunca se ha dado, ni está respaldada
> por Servitec Servicios Informáticos S.L.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
Hello Jason,
Sorry, I forget to post my configuration:
- SQL Server 2005 + Autodesk Map 3D 2007 SP3 + MGE and java viewer
- Mysql 5.0 + Autodesk Map 3D 2007 SP3 + MGOS 1.0.2 and the latest mysql
fdo provider (I think R071...).
In both cases, the performance is bad in comparison with sdf based layers.
Thanks.
--
------------------------------------------------------------------------
Antonio Lucas
Software Engineer
alucas at sercad.com <mailto:alucas at sercad.com> www.sercad.com
<http://www.sercad.com>
963·959·513
Fax 963·731·756
SER&TEC
avda. Ausias March 79 - 1
46013 Valencia
Este mensaje puede contener información confidencial, privilegiada o
datos de carácter personal. Si usted no es el destinatario indicado en
el mismo o el responsable de su entrega, le rogamos no copie o entregue
este mensaje a nadie más. En dicho caso, por favor, destruya este
mensaje y comunique a Sercitec Servicios Informáticos S.L. su recepción.
Las opiniones, conclusiones y demás información incluida en este mensaje
que no está relacionada con asuntos profesionales de Servitec Servicios
Informáticos S.L. se entenderá que nunca se ha dado, ni está respaldada
por Servitec Servicios Informáticos S.L.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20061020/5314467d/attachment.html
More information about the Mapguide-users
mailing list