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: [email protected] [mailto:[email protected]] On Behalf Of elliott17 Sent: Monday, July 25, 2011 12:00 PM To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
