[mapguide-users] Problems with spatial select on MSSQL based layer

[Gregor Skrt]

I'm using SQL server 2008 R2 for most of my spatial layers in MGOS 2.5. lately spatial queries / selection on cadaster with 130.000 parcels became very slow and tooltips doesn't work as fast as before. Any idea why could that be ? What are basic rules to make optimize MSSQL layers for mapguide?  Most layers must be unfortunately based on MSSQL .

Thank you !

Gregor Skrt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20130906/66b6676d/attachment.html>