Select to view content in your preferred language

SqlServer Spaital View slow rendering

553
3
10-25-2022 12:17 AM
adnanmacor
New Contributor

I am working as GIS Consultant. Client is using ArcGIS Enterprise Standard. They have developed some spatial views in Sql-Server. These views return the result within one second in Management Studio. But when we load that view in ArcGIS Desktop it is taking 5-10mins to open the attribute table and sometime give invalid field error. Can someone assist in this matter.

thanks.

0 Kudos
3 Replies
RandyKreuziger1
Frequent Contributor

Are all the fields in the spatial view value ESRI field types?

How many records?

Are you using Definition Queries in Desktop or are you using the all the records?

Are you bringing the whole dataset in as is or have you set symbolization?

0 Kudos
DEWright_CA
Frequent Contributor

Is this coming from a Spatial DB? meaning enabled by ArcGIS? If so have you registered the views with ArcCatalog? Once you have you can add indexes to help speed spatial performance.

0 Kudos
Scott_Tansley
MVP Regular Contributor

So many potential reasons, but I'll ask this:

A lot of people test with SSMS will be using it on the machine where SQL is installed, which could be in your local server room.  But ArcGIS Enterprise 'could' be in the cloud, and in a completely different physical location.  

Do you know the physical locations of your database and application servers?

The impacts of bandwidth and latency can have a drastic impact on performance, so we need to rule that out.

 

Scott Tansley
https://www.linkedin.com/in/scotttansley/