AnsweredAssumed Answered

Varied Performance of Spatial View based on Desktop Version

Question asked by JSpence@bellevuewa.gov_cobgis on Dec 13, 2019
Latest reply on Dec 18, 2019 by ndei-esristaff

Has anyone run into this issue?  We have a spatial view (registered) on a 10.5.1 SDE database in SQL Server 2016 that under ArcGIS Desktop 10.3.1 renders in 4 seconds.  This same view in 10.5.1, 10.6.1, and 10.7.1 will take about 4 minutes to complete.  The draw methods appear to be the same for 10.5.1-10.7.1 too so it appears they are reading the view the same way.  I checked SDE intercept between the 4 different versions and everything appears good to go there.  I even cleared out execution plans from SSMS and rebuilt them from the ground up to see if there was a way to get better performance from it.  Maybe I missing the boat.  Anyone run into something similar in the past?

 

Thanks ahead of time for your thoughts.

Outcomes