Table joins will slow down feature updating.

FayuLai — Mon, 27 Apr 2020 23:41:31 GMT

Updating data to a feature class will be slow when there are some tables joined to it. The following is the function we used to update the data. The performances on a feature class with table joined and without table joined are very different. We are able to duplicate this issue in 2.3, 2.4 and 2.5.

private async Task<bool> UpdateType(FeatureLayer pFeatLyr, List<long> oidSet, string sType)

{

var op = new EditOperation();

FeatureClass pFeatCls = await CHaLayerSrv.GetFeatureClass(pFeatLyr);

//FeatureClass pFeatCls = ((FeatureLayer)pFeatLyr).GetFeatureClass();

try

{

op.Callback(async context =>

{

StringBuilder sb = new StringBuilder();

sb.Append("OBJECTID IN(");

foreach (long objId in oidSet)

{

sb.Append(objId.ToString() + ",");

}

sb.Remove(sb.Length - 1, 1).Append(")");

string query = sb.ToString();

using (RowCursor pFeatCur = await CHaMapSelection.SearchFeatures(pFeatCls, query, "", false))

{

while (pFeatCur != null && pFeatCur.MoveNext())

{

using (Feature pFeat = (Feature)pFeatCur.Current)

{

context.Invalidate(pFeat);

pFeat[GlobalConst.SHAPE_TITLE_TYPE] = sType;

pFeat.Store();

context.Invalidate(pFeat);

}

}, pFeatCls);

if (!op.Execute())

{

Console.WriteLine(op.ErrorMessage);

return false;

}

else

{

return true;

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

return false;

}

finally

{

if (pFeatCls != null)

{

pFeatCls.Dispose();

pFeatCls = null;

}

We have reported similar issue before. But we are still not able to solve this problem. Any help will be greatly appreciated.

topic Table joins will slow down feature updating. in ArcGIS Pro SDK Questions

Table joins will slow down feature updating.