[mapguide-users] mapguide and mssql low performance problem

[RenoSun]

Hi Abbasali,

Did set up the spatial indexes for your mssql tables?

Please see the following link to figure out the best spatial index setting
for your data tables:

The Black Art Of Spatial Index Tuning In SQL Server
<http://boomphisto.blogspot.ca/2011/04/black-art-of-spatial-index-tuning-in.html>  

Your data tables are huge, and normally the performance of using mssql with
mapguide is worse than using SQLite/SDF files.

You may want to try to convert your mssql tables into SQLites spatial to see
if mapguide will be able to load faster.

Generalize the coordinates of your geometries will help too, but it will
scarify a little bit accuracy. Like make your each coordinates to only 3
decimal places. If you are using LL84, please keep at least 6-7 decimal for
each coordinates.

Don't join your mssql tables on mapguide or AIMS with other spatial tables,
because it usually will make it slower or very slow.





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapguide-and-mssql-low-performance-problem-tp5276761p5278082.html
Sent from the MapGuide Users mailing list archive at Nabble.com.