[mapguide-users] Re: MSSQL 2008 R2 and MGOS 2.2

[Martin Morrison]

Just for reference my database has 43 tables and 0 views.  It works, is stable and is fast.

I presume you have the spatial indexes properly built and no bad geometry?  Have you run MakeValid() on your tables?

Martin Morrison
Application Engineer
Engineering Design Systems, Inc.
3780 Peters Creek Rd Ext SW
Roanoke, VA  24018
540.345.1410
gis.edsi.com


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of elliott17
Sent: Monday, July 25, 2011 12:00 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Re: MSSQL 2008 R2 and MGOS 2.2

The SQL queries are running in less than 5 seconds.  The execution time-out
setting is set to 0 (unlimited).

My PHP time out settings is 120 seconds.

Of the sites that are not loading, the largest database has 60 tables. 
Another database has 18 tables and 40 views (not all accessed by MapGuide). 
Another site has 12 tables.

Some sites are running where other sites are not loading the map. When the
map does not load, I do not get the legend or the right click menu within
the map.

I have 2.0.2 loading these sites with no issues and they read the same
tables from SQL Server 2008.

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/MSSQL-2008-R2-and-MGOS-2-2-tp6604255p6618891.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