[mapguide-users] bad performance with mysql or sql server

SER&TEC Antonio Lucas alucas at srtec.com
Fri Oct 20 03:57:03 EDT 2006


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.





More information about the Mapguide-users mailing list