Pro 3.5.3 Painfully Slow

[luckachi]

For the last few days I have been trying to update a hosted feature layer from a local SDE layer we have. Normally, a script processes the update to AGO but we recently adding 90K + data points and the script apparently couldn't handle it.

I have been joining the tables to see what records are missing (based on Record ID) and Pro has been horribly slow, sometimes taking hours just to sort the attribute table. Right now I have the SDE table joined to the hosted feature layer to update a few fields and I've been waiting almost an hour for the edits to save on just 16k points. 

Any insight would be appreciated because at this rate its going to take me a week to get anything done.

[Joshua-Young]

Making sure there is an attribute index on the joining fields on both the SDE and hosted feature layer side should help some. Also, I do not think hosted feature layers on AGO like massive single edit operations. If you look on Esri Community there are posts about doing batch edits using the ArcGIS for Python API.

[luckachi]

I don't believe I've ever selected the index join fields but when I try I keep getting an error message. However, the join is successful without indexing.

[MichaelVolz]

Do you perform a truncate and append from SDE to the hosted feature layer (hfl) or just an append of new features to the hfl?

[luckachi]

Just append. Pro will not allow me to truncate the hfl - I always get 

ERROR 001260: Operation not supported on table

[Joshua-Young]

I would guess the account that ran the Add Join did not have permission to add an index to either the SDE layer or the hosted feature layer. I would recommend adding the indexes manually outside of the Add Join tool.

For hosted feature services you can add an index on the item's Setting page.

For SDE layers you can add an index from the Catalog pane through a database connection that uses an account that has permission to add an index. Expand the database connection in the Catalog pane, find your layer, right click properties, select the Indexes tab, and add an index on the join field.