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.



QueryFilter qf = new QueryFilter();

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

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