Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

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

Slow IMS 2012 & SQL Server Spatial

313 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: 282
Registered: ‎10-06-2008
Message 2 of 5 (292 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 (284 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 (195 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: 392
Registered: ‎10-10-2003
Message 5 of 5 (176 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
Need installation help?

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