Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

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

Slow IMS 2012 & SQL Server Spatial

316 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: 284
Registered: ‎10-06-2008
Message 2 of 5 (295 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: 21
Registered: ‎05-16-2006
Message 3 of 5 (287 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
Contributor
reno.sun.gis
Posts: 11
Registered: ‎05-24-2013
Message 4 of 5 (198 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: 426
Registered: ‎10-10-2003
Message 5 of 5 (179 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.