topic Has anybody had latency issues with Spatial Views in Server? in ArcGIS Enterprise Questions

Has anybody had latency issues with Spatial Views in Server?

andrewj_ca — Wed, 22 Jun 2016 17:11:41 GMT

We've been experiencing performance issues with spatial views within our Server environment. This is new since our upgrade to 10.3.1. Any ideas? Thanks

Re: Has anybody had latency issues with Spatial Views in Server?

ChristianWells — Wed, 22 Jun 2016 18:47:53 GMT

Hi Andrew,

What version did you upgrade from? Were your spatial views previously registered with the geodatabase or is this a stand-alone instance?

Spatial views (Query Layers) do have additional overhead when compared to feature classes or tables.

Re: Has anybody had latency issues with Spatial Views in Server?

andrewj_ca — Thu, 23 Jun 2016 11:35:20 GMT

I migrated from 10.0 to 10.3.1, that being said, I didn't migrate the views, I recreated them post migration.

Re: Has anybody had latency issues with Spatial Views in Server?

ChristianWells — Thu, 23 Jun 2016 15:18:23 GMT

It sounds like you would have had them registered at 10.0 using either the sdelayer -o register or sdetable -o create view. Does that sound familiar? If so, that might explain the performance hit you are seeing at 10.3.1 with views after recreating them.

To address the performance you may want to consider using the SDE 10.2.2 command line tools to register your views at 10.3.1.

Re: Has anybody had latency issues with Spatial Views in Server?

andrewj_ca — Thu, 23 Jun 2016 15:23:51 GMT

Thanks for your response Christian. Turns out that the issue was within the MXD itself. Legacy MXD didn't know about "Query Layers". Once I added the views back in to the MXD as Query layers everything was right in the world again.

Cheers