topic Re: Spatial Indexes and Load Only IO Mode in Data Management Questions

Spatial Indexes and Load Only IO Mode

NathanHeick — Fri, 27 Apr 2012 21:53:43 GMT

Good Afternoon,

Does anyone know if there is a difference between using the sdelayer -o load_only_io command versus the arcpy.management.RemoveSpatialIndex() function. I would like to know if there is anything else going on in the background with load_only_io mode. We are running several Spatial ETL tools and I want to improve performance during the loading of the data, but don't want the spatial indexes to get rebuilt at the end of any of the Spatial ETL tools. I am confident the sdelayer command would work, but if the arcpy function is identical, it is much simpler to write a script tool that only uses the arcpy module versus the subprocess module. I am not sure what can trigger the spatial indexes to be rebuilt. I want to control when that happens.

Thanks,

Nathan

Re: Spatial Indexes and Load Only IO Mode

JonDeRose — Fri, 04 May 2012 12:45:45 GMT

Nathan,

'sdelayer -o load_only_io' does much the same thing as the arcpy.management.RemoveSpatialIndex(). Either would improve the performance when loading objects as you would not have the index to navigate. Load_only_io goes a bit further than the arcpy function however and places a flag on the feature class metadata that will only enable store and replace I/O operations. In other words, while dropping the spatial index alone will not prevent editing within ArcGIS, setting a feature class to load_only_io will. Hope that helps.

- Jon

Re: Spatial Indexes and Load Only IO Mode

NathanHeick — Mon, 07 May 2012 02:01:56 GMT

Thanks Jon,

I was looking for that extra piece of information. I suspected there was some difference.

Nathan