AUTOREPLY [mapguide-users] SQL Server 2008 slow performance

[m.roth at gds-team.de]

Sehr geehrte Damen und Herren,
 
vom 24.08.2009 bis einschlielich 28.08.2009 befinde ich mich im Urlaub. Ihre E-Mail wurde hausintern weitergeleitet.
Ab dem 31.08.2009 bin ich wieder fr Sie erreichbar. 
 
Mit freundlichen Gren
 
Markus Roth 


GDS Geo Daten Service GmbHWilbecke 14
46325 Borken
Tel. 02861/9201-62
Fax. 02861/9201-79
E-Mail m.roth at gds-team.de
Internet www.gds-online.net 
 
 
Geschftsfhrer 
Dipl.-Ing.Reinhold Heisterkamp
Amtsgericht Coesfeld HRB 4893

I was trying to load data from SQL Server 2008 using the Osgeo FDO Provider
for SQL Server Spatial data connection in MapGuide Enterprise 2010.  It
seems slower than shapefiles when previewing in MapGuide Studio.  I find SDF
format to be the fastest of the 3 formats.

I originally had a shapefile about 100 MB in size.  The loading time in
MapGuide:
SQL Server - 41 seconds
Shapefile - 30 seconds
SDF - 15 seconds

Any ideas how to make loading from SQL Server data faster with MapGuide? 
Does it have something to do with FDO provider?
-- 
View this message in context: http://n2.nabble.com/SQL-Server-2008-slow-performance-tp3496285p3496285.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090822/f865d71c/attachment.html