Slow IMS 2012 & SQL Server Spatial

[ced_abitat]

Hi,

  I have a table in SQL Server Spatial containing the points (field type geography with  spatial index set HIGH-HIGH-HIGH-HIGH) and I would like to see them withInfrastructure MapServer 2012. I can view them but it is really slow. If you use the ODBC connection as the display of these points (using X,Y fields) turns out to be much faster. How can I speed up the configuration that uses the SQL Spatial?

I also tried with the 2014 version but does not improve performance

Regards

[jackie.ng]

Does the bounds of that spatial index cover your area of interest and not the entire planet?

- Jackie

[ced_abitat]

Hi Jackie,
on Sql Server Spatial only for geometry columns is possible to specify the area of index. I have geography column.
Regards
Matteo

[reno.sun.gis]

Hi

You may need to generalize your  Lat, Lng coordinates with only 6-7 decimal places

Please let me know if that works or not.

Thanks 

[gluckett]

First make sure your data is valid:

update mytable
set mygeom = mygeom.MakeValid()

Second, in your layer in Studio, filter out any NULL geometries/geographies