AnsweredAssumed Answered

Feature class joined to database performance issues.

Question asked by kundalay1 on Jun 17, 2016
Latest reply on Jun 29, 2016 by kundalay1

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.