topic Re: Feature class joined to database performance issues. in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876953#M6556 <HTML><HEAD></HEAD><BODY><P>Thanks guys that really did work and performance is significantly better now. </P></BODY></HTML> Wed, 29 Jun 2016 21:55:44 GMT Anish_Adhikari 2016-06-29T21:55:44Z Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876947#M6550 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 17 Jun 2016 17:09:14 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876947#M6550 Anish_Adhikari 2016-06-17T17:09:14Z Re: Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876948#M6551 <HTML><HEAD></HEAD><BODY><P>HI Anish,</P><P></P><P>Can you add the following information:</P><P></P><P>ArcGIS Client used?</P><P></P><P>What is the name and version of the RDBMS you are using?</P><P></P><P>What version is the Geodatabase?</P><P></P><P>For the joined data, it is in the same database (no registered with the geodatabase) or in another completely different database?</P><P></P><P>How long is too long?</P><P></P><P>With out the above information it will be difficult for people to help.</P><P></P><P><A href="https://community.esri.com/space/2100">ArcGIS for Server</A>​</P></BODY></HTML> Fri, 17 Jun 2016 18:09:32 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876948#M6551 George_Thompson 2016-06-17T18:09:32Z Re: Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876949#M6552 <HTML><HEAD></HEAD><BODY><P>George, thank you for your response. Here is the information.</P><P></P><P>ArcGIS client : Desktop 10.3.1</P><P>Database : SQL server 2008 R2</P><P>Geodatabase version : unknown</P><P>Feature class is on a File GDB and joined table exists on a separate standalone sql database view. </P><P>It takes few minutes for everything to load and if zoomed in or out, same amount of time.</P></BODY></HTML> Fri, 17 Jun 2016 18:20:44 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876949#M6552 Anish_Adhikari 2016-06-17T18:20:44Z Re: Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876950#M6553 <HTML><HEAD></HEAD><BODY><P>Anish,</P><P></P><P>Do you have attribute indexes created on the fields that create the join?</P></BODY></HTML> Fri, 17 Jun 2016 19:06:25 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876950#M6553 JakeSkinner 2016-06-17T19:06:25Z Re: Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876951#M6554 <HTML><HEAD></HEAD><BODY><P>Based on that information, I would wonder how any join between a file geodatabase and another SQL Server database view would perform.</P></BODY></HTML> Fri, 17 Jun 2016 19:14:11 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876951#M6554 George_Thompson 2016-06-17T19:14:11Z Re: Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876952#M6555 <HTML><HEAD></HEAD><BODY><P>I will try adding indexes and see how it will work. Thank You for your help.</P></BODY></HTML> Fri, 17 Jun 2016 21:38:07 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876952#M6555 Anish_Adhikari 2016-06-17T21:38:07Z Re: Feature class joined to database performance issues. https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876953#M6556 <HTML><HEAD></HEAD><BODY><P>Thanks guys that really did work and performance is significantly better now. </P></BODY></HTML> Wed, 29 Jun 2016 21:55:44 GMT https://community.esri.com/t5/geodatabase-questions/feature-class-joined-to-database-performance/m-p/876953#M6556 Anish_Adhikari 2016-06-29T21:55:44Z