Check your spatial indexes and the area they cover (ie. Not covering the whole planet).
Use RDBMS provider trace logging (http://themapguyde.blogspot.com.au/2013/01/mapguide-tidbits-fdo-rdbms-provider.html) to see what SQL is being executed and combine it with your query analysis/planning tools in SQL Server to see where it is bottlenecking. - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problems-with-spatial-select-on-MSSQL-based-layer-tp5076371p5076375.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
