topic Is there danger of getting cached data when querying a featurelayer that has been added to the map? in ArcGIS Pro SDK Questions

Is there danger of getting cached data when querying a featurelayer that has been added to the map?

Gurunara — Mon, 24 Jun 2024 13:30:51 GMT

Found that by adding featurelayers to the current active map using something like:

LayerFactory.Instance.CreateLayer<FeatureLayer>(layerParams, MapView.Active.Map);

it's faster to query against this feature layer using:

var featureLayer = //get from layer added to map already

using (var table = featureLayer.GetTable())
var queryFilter = new QueryFilter
{WhereClause = whereClause,};
using (var rowCursor = table.Search(queryFilter))
...

I know there is a setting on the featurelayer from ArcPro to refresh the layer periodically... (see attachment)

My concern is does this mean that data can be stale between these refresh intervals, or even if the setting is turned off? Does query return the latest/real time data always, or does it return the cached data?

Re: Is there danger of getting cached data when querying a featurelayer that has been added to the map?

UmaHarano — Tue, 25 Jun 2024 21:08:13 GMT

@Gurunara

A direct query to the data/layer made in the SDK should always hit the database.

Re: Is there danger of getting cached data when querying a featurelayer that has been added to the map?

Gurunara — Wed, 26 Jun 2024 19:28:48 GMT

So (just to confirm) you're saying that the query i am using, as below, is always hitting the database?

var featureLayer = //get from layer added to map already

using (var table = featureLayer.GetTable())
var queryFilter = new QueryFilter
{WhereClause = whereClause,};
using (var rowCursor = table.Search(queryFilter))
...

Thanks.

Re: Is there danger of getting cached data when querying a featurelayer that has been added to the map?

UmaHarano — Thu, 27 Jun 2024 19:07:42 GMT

Correct! It should query the underlying database.