<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY style="FONT: 10pt Arial; COLOR: #000000" bgColor=#ffffff leftMargin=5
topMargin=5>
<DIV></DIV>
<DIV align=center><IMG src="cid:0394-0021-12-06-TJ-5"></DIV>
<DIV align=center> </DIV>
<DIV align=left>Sehr geehrte Damen und Herren,</DIV>
<DIV align=left> </DIV>
<DIV align=left>
<DIV align=left>
<DIV align=left>vom 24.08.2009 bis einschlielich 28.08.2009 befinde ich
mich im Urlaub. Ihre E-Mail wurde hausintern weitergeleitet.</DIV>
<DIV align=left>Ab dem 31.08.2009 bin ich wieder fr Sie erreichbar. </DIV>
<DIV align=left> </DIV>
<DIV align=left>
<DIV>Mit freundlichen Gren</DIV></DIV></DIV></DIV>
<DIV>
<DIV> </DIV>
<DIV>
<DIV>
<DIV>Markus Roth
<HR>
</DIV><STRONG>
<DIV>
<TABLE style="FONT: 10pt Courier New; WIDTH: 90%" borderColor=#ffffff
bgColor=#ffffff>
<CAPTION>
<DIV align=left><STRONG><FONT face=Arial>GDS Geo Daten Service
GmbH</FONT></STRONG></DIV></CAPTION>
<TBODY>
<TR>
<TD width="50%" bgColor=#ffffff>
<DIV><FONT face=Arial>Wilbecke 14</FONT></DIV>
<DIV><FONT face=Arial>46325 Borken</FONT></DIV>
<DIV><FONT face=Arial>Tel. 02861/9201-62</FONT></DIV>
<DIV><FONT face=Arial>Fax. 02861/9201-79</FONT></DIV>
<DIV>
<DIV align=left><FONT face=Arial>E-Mail </FONT><A
href="mailto:m.roth@gds-team.de"><FONT
face=Arial>m.roth@gds-team.de</FONT></A></DIV>
<DIV align=left><FONT face=Arial>Internet </FONT><A
href="http://www.gds-online.net"><FONT
face=Arial>www.gds-online.net</FONT></A></DIV></DIV></TD>
<TD width="50%" bgColor=#ffffff>
<DIV align=right><FONT face=Arial></FONT> </DIV>
<DIV align=right><FONT face=Arial></FONT> </DIV>
<DIV align=right><FONT face=Arial></FONT> </DIV>
<DIV align=right><FONT face=Arial>Geschftsfhrer </FONT></DIV>
<DIV align=right><FONT face=Arial>Dipl.-Ing.Reinhold
Heisterkamp</FONT></DIV>
<DIV align=right><FONT face=Arial>Amtsgericht Coesfeld HRB
4893</FONT></DIV></TD></TR></TBODY></TABLE></STRONG>
<HR>
</DIV></DIV></DIV></DIV><XMP>Actually, it is possible. I found performance gains by using SQL Server 2008. The keys to success are making sure you have the tables structured correctly and properly indexed. If you are using themes, then make multiple connections to the data and use SQL queries instead. I will agree that SDF is faster than SHP.
Martin
-----Original Message-----
From: mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] On Behalf Of Berdel, Brian
Sent: Monday, August 24, 2009 7:55 PM
To: 'MapGuide Users Mail List'
Subject: RE: [mapguide-users] SQL Server 2008 slow performance
I am not sure it is possible...I get the same results as far as speed and the different data connections you described.
Brian
-----Original Message-----
From: mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] On Behalf Of kevin_t
Sent: Saturday, August 22, 2009 3:37 PM
To: mapguide-users@lists.osgeo.org
Subject: [mapguide-users] SQL Server 2008 slow performance
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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
Important notice to recipients:
Copies of documents that may be relied upon by you are limited to the printed copies (also known as 'hard copies') that are signed and sealed by the Engineer and/or Land Surveyor. Files in electronic formats, or other types of information furnished by the Engineer and/or Land Surveyor to you such as text, data or graphics are for your convenience only. Any conclusions or information obtained or derived from such electronic files will be at the user's sole risk. When transferring documents in electronic formats, the Engineer and/or Land Surveyor makes no representation as to long-term compatibility, usability, or readability of the documents resulting from the use of software application packages, operating systems or computer hardware differing from those used by McMahon Associates, Inc. at the beginning of the project.
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
</XMP></BODY></HTML>