I have been using FME 2025.1 to update a table that has 1.7M records and 12 fields in ArcGIS Enterprise (AGE) for the last year and we are getting ready to move the webmap to ArcGIS Online (AGOL) later this year. The issue that I am having is that it is taking more than double the amount of time to update the table in AGOL. I’ve read the FME community comments and the Esri forums but haven’t been able to find an alternate solution that can improve the update speed.
My typical process has processing/enriching in FME and then the feature writer to truncate and insert into the feature layer in AGOL. The hosted feature layer also has a “View” as that is the portion that we would eventually show to the public. The update is run weekly and is automated in AGE using FME Flow, which is also the goal for AGOL. I am not a python wizard.
Does anyone have any suggestions or has anyone experienced the same issue and found the solution?
Thanks,
Peter