I have a feature service layer on my portal that I need to edit and update. The layer has about 430,000 records. When I used ArcGIS Pro for the field calculation function to edit a field and then appended new data to the layer, it took me 18 hours for the calculation and 20 hours for the append. That was too slow.
I decided to export the layer and republish it as a new one. Then I repeated the same steps of field calculation and append. This time, it only took me 20 minutes for both.
Why is there such a huge difference in the processing time? The original feature service is in other webapps and webmap so I really hope to fix it rather than replacing it.
Thank you guys
