Feature class joined to database performance issues.

2310
6
06-17-2016 10:09 AM
Highlighted
Occasional Contributor

We are having performance issues with feature classes joined with sql table views inside arcmap. We use this approach in arcmap as well as to publish the content as services to ArcGIS Server. The database gets constant updates so it is crucial that we maintain relationship between the feature class and sql view. There are typically 2000 to 4000 records on the joined table. The performance is very slow. We use this approach with many feature classes and tables and they show the same symptoms. Any help would be appreciated.

Reply
0 Kudos
6 Replies
Highlighted
Esri Frequent Contributor

HI Anish,

Can you add the following information:

ArcGIS Client used?

What is the name and version of the RDBMS you are using?

What version is the Geodatabase?

For the joined data, it is in the same database (no registered with the geodatabase) or in another completely different database?

How long is too long?

With out the above information it will be difficult for people to help.

ArcGIS for Server

--- George T.
Reply
0 Kudos
Highlighted
Occasional Contributor

George, thank you for your response. Here is the information.

ArcGIS client : Desktop 10.3.1

Database : SQL server 2008 R2

Geodatabase version : unknown

Feature class is on a File GDB and joined table exists on a separate standalone sql database view.

It takes few minutes for everything to load and if zoomed in or out, same amount of time.

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

Anish,

Do you have attribute indexes created on the fields that create the join?

Highlighted
Esri Frequent Contributor

Based on that information, I would wonder how any join between a file geodatabase and another SQL Server database view would perform.

--- George T.
Reply
0 Kudos
Highlighted
Occasional Contributor

I will try adding indexes and see how it will work. Thank You for your help.

Reply
0 Kudos
Highlighted
Occasional Contributor

Thanks guys that really did work and performance is significantly better now.

Reply
0 Kudos