Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Contributor
matteo.conte
Posts: 20
Registered: ‎05-16-2006
Message 1 of 5 (305 Views)

Slow IMS 2012 & SQL Server Spatial

305 Views, 4 Replies
12-20-2013 05:04 AM

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

Valued Mentor
jackie.ng
Posts: 278
Registered: ‎10-06-2008
Message 2 of 5 (284 Views)

Re: Slow IMS 2012 & SQL Server Spatial

12-22-2013 05:48 PM in reply to: matteo.conte

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

 

- Jackie

Contributor
matteo.conte
Posts: 20
Registered: ‎05-16-2006
Message 3 of 5 (276 Views)

Re: Slow IMS 2012 & SQL Server Spatial

12-23-2013 10:54 PM in reply to: matteo.conte
Hi Jackie,
on Sql Server Spatial only for geometry columns is possible to specify the area of index. I have geography column.
Regards
Matteo
Active Member
reno.sun.gis
Posts: 9
Registered: ‎05-24-2013
Message 4 of 5 (187 Views)

Re: Slow IMS 2012 & SQL Server Spatial

03-31-2014 04:18 PM in reply to: matteo.conte

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 :smileyhappy:

Valued Mentor
gluckett
Posts: 374
Registered: ‎10-10-2003
Message 5 of 5 (168 Views)

Re: Slow IMS 2012 & SQL Server Spatial

04-04-2014 09:12 AM in reply to: matteo.conte
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
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.