Select to view content in your preferred language

Improve performance of Delete Rows Geoprocessing tool when source data is ArcOnline feature service

8259
22
07-14-2021 12:28 AM
Status: Implemented
LindsayRaabe_FPCWA
MVP Regular Contributor

So with Pro 2.8, we got the much wanted improvements to the Append tool when appending features to a feature service in ArcOnline. This reduced upload times when appending hundreds or thousands of features from many, many mintutes/hours to mere seconds. 

It would be great if the same sort of improvement could be applied to the Delete Rows tool for when you're trying to do the opposite (still painfully slow). 

22 Comments
LindsayRaabe_FPCWA

Small update regarding Delete Rows vs Truncate Table: Truncate Table will work with feature services in ArcGIS Online, but only if they DON'T have Sync enabled. 

ArcGIS Pro Truncate Table GP Tool Could Work on Po... - Page 2 - Esri Community

LindsayRaabe_FPCWA

I just followed up on this after being approached by Esri to see if it was still a problem. We're now on 3.3.2 and it all seemed to work as advertised. Test results below. 

I tested by publishing a new feature service with 25,180 rows (polygons), then ran the whole lot through the Delete Rows tool ("Enable Undo" turned off). It took 1 min 51 secs to run (pretty good). 

I then ran the Append tool to upload the original 25,180 features again and that only took 55 secs to run.

LindsayRaabe_FPCWA_0-1744170612423.png