https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-recalculate-spatial-index-using-esri/m-p/1389957#M11551 <P>I am using Esri.FileGDB in a C# application to open File geodatabase to query and add new records into tables. I found that the insert operation becomes increasingly slow with increasing number of records in tables inside a file geodatabase, so I am thinking how to call recalculate spatial index after inserting a large number of records programmatically, could I have a code example, I searched high and lows but couldn't find any. Thanks.</P> Sun, 03 Mar 2024 05:30:51 GMT TongZhai 2024-03-03T05:30:51Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-recalculate-spatial-index-using-esri/m-p/1389957#M11551 <P>I am using Esri.FileGDB in a C# application to open File geodatabase to query and add new records into tables. I found that the insert operation becomes increasingly slow with increasing number of records in tables inside a file geodatabase, so I am thinking how to call recalculate spatial index after inserting a large number of records programmatically, could I have a code example, I searched high and lows but couldn't find any. Thanks.</P> Sun, 03 Mar 2024 05:30:51 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-recalculate-spatial-index-using-esri/m-p/1389957#M11551 TongZhai 2024-03-03T05:30:51Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-recalculate-spatial-index-using-esri/m-p/1474686#M11552 <P>Hi <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/549552">@TongZhai</a> - To address slower performance like yours, you can drop the indexes before the data insert and recreate them after insertion is complete using the <A href="https://github.com/Esri/arcgis-pro-sdk/wiki/ProConcepts-DDL#indexes" target="_self">DDL API.</A>&nbsp; The&nbsp;<A href="https://github.com/Esri/arcgis-pro-sdk/wiki/ProSnippets-Geodatabase" target="_blank">https://github.com/Esri/arcgis-pro-sdk/wiki/ProSnippets-Geodatabase</A>&nbsp;has code snippets to add/remove both spatial and attribute indexes.&nbsp;</P> Fri, 17 May 2024 17:46:25 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-recalculate-spatial-index-using-esri/m-p/1474686#M11552 Aashis 2024-05-17T17:46:25Z