AnsweredAssumed Answered

Creating views in SQLite using runtime database

Question asked by mikedmanak on May 30, 2018
Latest reply on Jul 10, 2018 by MDostal-esristaff

I'm increasingly running into situations where for whatever reason I end up querying all the features in a AGSGDBFeatureLayer and iterating through them to do X.  Typically X is pulling data for summary statistics of some sort, various counts of related things, tallying up distances, etc...

 

I'm wondering if it would be possible, and if anyone has attempted, to use the SQLite db powering the runtime database to create custom views.  The thought being that once a project database has been downloaded to a device a little routine could go in and join things up in views to power these summary activities and save the compute required to run these summary routines... which run a serious risk of causing trouble when we get into large quantities of data.

 

We do this all the time on the web side of things and I'm a bit jealous of our web developers.

Outcomes