nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Find more posts tagged with

Accepted answers

All comments

joyoung_kerrvilletx

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.

joyoung_kerrvilletx

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.

MikeVolz

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

Krocha

Ive been having this same issue and i only have less than 5k rows. I appended hosted feature layer to my SDE to calculate a field but omg it takes soooooooooooo long even just running the append tool.

MikeVolz

Have you performed the same operation in a previous version of Pro? If so, what version were you using and was the performance better?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.