AnsweredAssumed Answered

FeatureTable QueryAsync Performance

Question asked by BlairServicessLLC on Sep 13, 2017
Latest reply on Sep 15, 2017 by mnielsen-esristaff

I've got a tool that frequently queries a set of feature layers provided from a runtime Geodatabase. It just seems query performance is slower than I would expect.  I've made sure the queried fields are indexed, but that does not offer as much improvement as I had hoped.

 

I'm just using the QueryAsync method on a FeatureTable to return a set of features.  Nothing fancy.  Basically like the code below.

 

Is there a faster way?  I've looked a bit into the QueryTask class that seems to offer the option to limit the number of fields returned -- which could possibly be helpful, but have not had luck with this pointing at a runtime Geodatabase feature layer.

 

Thanks for any pointers.

Ed

 

QueryFilter qf = new QueryFilter();

qf.WhereClause = primaryLayer.FeederIDFieldName + " in (" + feederIDs + ")";

IEnumerable<Feature> resultFeatures = await featureTable.QueryAsync(qf);

Outcomes