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.
Hi @TongZhai - To address slower performance like yours, you can drop the indexes before the data insert and recreate them after insertion is complete using the DDL API. The https://github.com/Esri/arcgis-pro-sdk/wiki/ProSnippets-Geodatabase has code snippets to add/remove both spatial and attribute indexes.